eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_ACVAL_PVT dependencies on FND_API

Line 474: WHEN FND_API.G_EXC_ERROR THEN

470: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, ' Validation completed for Analysis Cycle' || l_edt_ac_id || '.');
471:
472: /*
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO zpb_acval_pvt_validate;
476: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
477: x_changeCurrentRun := 'Y';
478: return;

Line 479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

475: ROLLBACK TO zpb_acval_pvt_validate;
476: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
477: x_changeCurrentRun := 'Y';
478: return;
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: ROLLBACK TO zpb_acval_pvt_validate;
481: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
482: x_changeCurrentRun := 'Y';
483: return;

Line 651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,

647: -- zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*
651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,
652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,
653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');
654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));

Line 652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,

648: zpb_aw.execute('push oknullstatus ');
649: zpb_aw.execute('oknullstatus=y');
650: /*
651: zpb_aw.initialize_workspace(1.0, FND_API.G_FALSE,
652: FND_API.G_VALID_LEVEL_FULL, return_status, msg_count,
653: msg_data, fnd_global.user_id, 'ZPB_MANAGER_RESP');
654: */
655: zpb_log.write_event(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
656: zpb_aw.execute('call sv.get.solvedef('''||p_analysis_cycle_id||''' NA yes)');

Line 679: -- zpb_aw.clean_workspace(1.0, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data);

675:
676: zpb_log.write_statement(G_PKG_NAME||l_api_name,zpb_aw.interp('rpr w 30 aw(list)'));
677:
678: -- dont call clean_workspace because it resets the context also. Will have to fix this later.
679: -- zpb_aw.clean_workspace(1.0, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data);
680:
681: end detach_aw;
682:
683:

Line 1177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1173: end validate_generate_worksheet;
1174:
1175: PROCEDURE validate_input_selections(
1176: p_api_version IN NUMBER,
1177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1180: x_return_status OUT NOCOPY VARCHAR2 ,
1181: x_msg_count OUT NOCOPY NUMBER,

Line 1178: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1174:
1175: PROCEDURE validate_input_selections(
1176: p_api_version IN NUMBER,
1177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1180: x_return_status OUT NOCOPY VARCHAR2 ,
1181: x_msg_count OUT NOCOPY NUMBER,
1182: x_msg_data OUT NOCOPY VARCHAR2,

Line 1179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1175: PROCEDURE validate_input_selections(
1176: p_api_version IN NUMBER,
1177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1180: x_return_status OUT NOCOPY VARCHAR2 ,
1181: x_msg_count OUT NOCOPY NUMBER,
1182: x_msg_data OUT NOCOPY VARCHAR2,
1183: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 1348: IF NOT FND_API.Compatible_API_Call( l_api_version,

1344: begin
1345: -- Standard Start of API savepoint
1346: SAVEPOINT validate_input_selections;
1347: -- Standard call to check for call compatibility.
1348: IF NOT FND_API.Compatible_API_Call( l_api_version,
1349: p_api_version,
1350: l_api_name,
1351: G_PKG_NAME)
1352: THEN

Line 1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1349: p_api_version,
1350: l_api_name,
1351: G_PKG_NAME)
1352: THEN
1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1354: END IF;
1355:
1356: -- Initialize message list if p_init_msg_list is set to TRUE.
1357: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1357: IF FND_API.to_Boolean(p_init_msg_list) THEN

1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1354: END IF;
1355:
1356: -- Initialize message list if p_init_msg_list is set to TRUE.
1357: IF FND_API.to_Boolean(p_init_msg_list) THEN
1358: FND_MSG_PUB.initialize;
1359: END IF;
1360:
1361: -- Initialize API return status to success

Line 1362: x_return_status := FND_API.G_RET_STS_SUCCESS;

1358: FND_MSG_PUB.initialize;
1359: END IF;
1360:
1361: -- Initialize API return status to success
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363: x_isvalid := 'Y';
1364: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve input levels');
1365: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
1366: l_alldims_invalid := 'N';

Line 1533: WHEN FND_API.G_EXC_ERROR THEN

1529: x_invalid_linemem_list := substr(x_invalid_linemem_list,2,length(x_invalid_linemem_list)-1);
1530: end if;
1531:
1532: exception
1533: WHEN FND_API.G_EXC_ERROR THEN
1534: ROLLBACK TO validate_input_selections;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: FND_MSG_PUB.Count_And_Get(
1537: p_count => x_msg_count,

Line 1535: x_return_status := FND_API.G_RET_STS_ERROR;

1531:
1532: exception
1533: WHEN FND_API.G_EXC_ERROR THEN
1534: ROLLBACK TO validate_input_selections;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: FND_MSG_PUB.Count_And_Get(
1537: p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );

Line 1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1536: FND_MSG_PUB.Count_And_Get(
1537: p_count => x_msg_count,
1538: p_data => x_msg_data
1539: );
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: ROLLBACK TO validate_input_selections;
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: FND_MSG_PUB.Count_And_Get(
1544: p_count => x_msg_count,

Line 1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1538: p_data => x_msg_data
1539: );
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: ROLLBACK TO validate_input_selections;
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: FND_MSG_PUB.Count_And_Get(
1544: p_count => x_msg_count,
1545: p_data => x_msg_data
1546: );

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1545: p_data => x_msg_data
1546: );
1547: WHEN OTHERS THEN
1548: ROLLBACK TO validate_input_selections;
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: x_isvalid := 'N';
1551: --dbms_output.put_line(to_char(sqlcode) || substr(sqlerrm,1,200));
1552: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
1553: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1585:
1586:
1587: PROCEDURE validate_solve_levels(
1588: p_api_version IN NUMBER,
1589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1590: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1592: x_return_status OUT NOCOPY VARCHAR2 ,
1593: x_msg_count OUT NOCOPY NUMBER,

Line 1590: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1586:
1587: PROCEDURE validate_solve_levels(
1588: p_api_version IN NUMBER,
1589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1590: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1592: x_return_status OUT NOCOPY VARCHAR2 ,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2,

Line 1591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1587: PROCEDURE validate_solve_levels(
1588: p_api_version IN NUMBER,
1589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1590: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1592: x_return_status OUT NOCOPY VARCHAR2 ,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2,
1595: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 1699: IF NOT FND_API.Compatible_API_Call( l_api_version,

1695: begin
1696: -- Standard Start of API savepoint
1697: SAVEPOINT validate_solve_levels;
1698: -- Standard call to check for call compatibility.
1699: IF NOT FND_API.Compatible_API_Call( l_api_version,
1700: p_api_version,
1701: l_api_name,
1702: G_PKG_NAME)
1703: THEN

Line 1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1700: p_api_version,
1701: l_api_name,
1702: G_PKG_NAME)
1703: THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1708: IF FND_API.to_Boolean(p_init_msg_list) THEN

1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN
1709: FND_MSG_PUB.initialize;
1710: END IF;
1711:
1712: -- Initialize API return status to success

Line 1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

1709: FND_MSG_PUB.initialize;
1710: END IF;
1711:
1712: -- Initialize API return status to success
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;
1714: x_isvalid := 'Y';
1715:
1716: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
1717:

Line 1826: WHEN FND_API.G_EXC_ERROR THEN

1822: x_invalid_linemem_list := substr(x_invalid_linemem_list,2,length(x_invalid_linemem_list)-1);
1823: end if;
1824:
1825: exception
1826: WHEN FND_API.G_EXC_ERROR THEN
1827: ROLLBACK TO validate_solve_levels;
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(
1830: p_count => x_msg_count,

Line 1828: x_return_status := FND_API.G_RET_STS_ERROR;

1824:
1825: exception
1826: WHEN FND_API.G_EXC_ERROR THEN
1827: ROLLBACK TO validate_solve_levels;
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(
1830: p_count => x_msg_count,
1831: p_data => x_msg_data
1832: );

Line 1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1829: FND_MSG_PUB.Count_And_Get(
1830: p_count => x_msg_count,
1831: p_data => x_msg_data
1832: );
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: ROLLBACK TO validate_solve_levels;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: FND_MSG_PUB.Count_And_Get(
1837: p_count => x_msg_count,

Line 1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1831: p_data => x_msg_data
1832: );
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: ROLLBACK TO validate_solve_levels;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: FND_MSG_PUB.Count_And_Get(
1837: p_count => x_msg_count,
1838: p_data => x_msg_data
1839: );

Line 1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1839: );
1840: WHEN OTHERS THEN
1841: ROLLBACK TO validate_solve_levels;
1842: --dbms_output.put_line(to_char(sqlcode) || substr(sqlerrm,1,190));
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844: x_isvalid := 'N';
1845: --dbms_output.put_line(to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
1846: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
1847: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1858: end validate_solve_levels;
1859:
1860: PROCEDURE val_template_le_model(
1861: p_api_version IN NUMBER,
1862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1865: x_return_status OUT NOCOPY VARCHAR2 ,
1866: x_msg_count OUT NOCOPY NUMBER,

Line 1863: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1859:
1860: PROCEDURE val_template_le_model(
1861: p_api_version IN NUMBER,
1862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1865: x_return_status OUT NOCOPY VARCHAR2 ,
1866: x_msg_count OUT NOCOPY NUMBER,
1867: x_msg_data OUT NOCOPY VARCHAR2,

Line 1864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1860: PROCEDURE val_template_le_model(
1861: p_api_version IN NUMBER,
1862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1865: x_return_status OUT NOCOPY VARCHAR2 ,
1866: x_msg_count OUT NOCOPY NUMBER,
1867: x_msg_data OUT NOCOPY VARCHAR2,
1868: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 1911: IF NOT FND_API.Compatible_API_Call( l_api_version,

1907:
1908: -- Standard Start of API savepoint
1909: SAVEPOINT val_gentemp_le_model;
1910: -- Standard call to check for call compatibility.
1911: IF NOT FND_API.Compatible_API_Call( l_api_version,
1912: p_api_version,
1913: l_api_name,
1914: G_PKG_NAME)
1915: THEN

Line 1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1912: p_api_version,
1913: l_api_name,
1914: G_PKG_NAME)
1915: THEN
1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918:
1919: -- Initialize message list if p_init_msg_list is set to TRUE.
1920: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1920: IF FND_API.to_Boolean(p_init_msg_list) THEN

1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918:
1919: -- Initialize message list if p_init_msg_list is set to TRUE.
1920: IF FND_API.to_Boolean(p_init_msg_list) THEN
1921: FND_MSG_PUB.initialize;
1922: END IF;
1923:
1924: -- Initialize API return status to success

Line 1925: x_return_status := FND_API.G_RET_STS_SUCCESS;

1921: FND_MSG_PUB.initialize;
1922: END IF;
1923:
1924: -- Initialize API return status to success
1925: x_return_status := FND_API.G_RET_STS_SUCCESS;
1926:
1927: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, 'Validating if template lines exist in model ' || to_char(p_analysis_cycle_id) || '.');
1928: x_isvalid := 'Y';
1929: -- initialize_solve_object(p_analysis_cycle_id);

Line 2004: WHEN FND_API.G_EXC_ERROR THEN

2000:
2001: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, ' Validation completed for Analysis Cycle' || p_analysis_cycle_id || '.');
2002:
2003: exception
2004: WHEN FND_API.G_EXC_ERROR THEN
2005: ROLLBACK TO val_gentemp_le_model;
2006: x_return_status := FND_API.G_RET_STS_ERROR;
2007: FND_MSG_PUB.Count_And_Get(
2008: p_count => x_msg_count,

Line 2006: x_return_status := FND_API.G_RET_STS_ERROR;

2002:
2003: exception
2004: WHEN FND_API.G_EXC_ERROR THEN
2005: ROLLBACK TO val_gentemp_le_model;
2006: x_return_status := FND_API.G_RET_STS_ERROR;
2007: FND_MSG_PUB.Count_And_Get(
2008: p_count => x_msg_count,
2009: p_data => x_msg_data
2010: );

Line 2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2007: FND_MSG_PUB.Count_And_Get(
2008: p_count => x_msg_count,
2009: p_data => x_msg_data
2010: );
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: ROLLBACK TO val_gentemp_le_model;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: FND_MSG_PUB.Count_And_Get(
2015: p_count => x_msg_count,

Line 2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2009: p_data => x_msg_data
2010: );
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: ROLLBACK TO val_gentemp_le_model;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: FND_MSG_PUB.Count_And_Get(
2015: p_count => x_msg_count,
2016: p_data => x_msg_data
2017: );

Line 2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2016: p_data => x_msg_data
2017: );
2018: WHEN OTHERS THEN
2019: ROLLBACK TO val_gentemp_le_model;
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: x_isvalid := 'N';
2022: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2023: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2024: FND_MSG_PUB.Add_Exc_Msg(

Line 2044: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2040: -- 'N': The union of Line Members of ALL Generate Template Tasks is different from the
2041: -- NON_INITIALIZED inputted line members of Solve
2042: procedure val_solveinp_eq_gentemp(
2043: p_api_version IN NUMBER,
2044: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2045: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2046: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2047: x_return_status OUT NOCOPY VARCHAR2 ,
2048: x_msg_count OUT NOCOPY NUMBER,

Line 2045: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2041: -- NON_INITIALIZED inputted line members of Solve
2042: procedure val_solveinp_eq_gentemp(
2043: p_api_version IN NUMBER,
2044: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2045: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2046: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2047: x_return_status OUT NOCOPY VARCHAR2 ,
2048: x_msg_count OUT NOCOPY NUMBER,
2049: x_msg_data OUT NOCOPY VARCHAR2,

Line 2046: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2042: procedure val_solveinp_eq_gentemp(
2043: p_api_version IN NUMBER,
2044: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2045: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2046: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2047: x_return_status OUT NOCOPY VARCHAR2 ,
2048: x_msg_count OUT NOCOPY NUMBER,
2049: x_msg_data OUT NOCOPY VARCHAR2,
2050: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 2084: IF NOT FND_API.Compatible_API_Call( l_api_version,

2080: begin
2081: -- Standard Start of API savepoint
2082: SAVEPOINT val_gentemp_le_model;
2083: -- Standard call to check for call compatibility.
2084: IF NOT FND_API.Compatible_API_Call( l_api_version,
2085: p_api_version,
2086: l_api_name,
2087: G_PKG_NAME)
2088: THEN

Line 2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2085: p_api_version,
2086: l_api_name,
2087: G_PKG_NAME)
2088: THEN
2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090: END IF;
2091:
2092: -- Initialize message list if p_init_msg_list is set to TRUE.
2093: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2093: IF FND_API.to_Boolean(p_init_msg_list) THEN

2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090: END IF;
2091:
2092: -- Initialize message list if p_init_msg_list is set to TRUE.
2093: IF FND_API.to_Boolean(p_init_msg_list) THEN
2094: FND_MSG_PUB.initialize;
2095: END IF;
2096:
2097: -- Initialize API return status to success

Line 2098: x_return_status := FND_API.G_RET_STS_SUCCESS;

2094: FND_MSG_PUB.initialize;
2095: END IF;
2096:
2097: -- Initialize API return status to success
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;
2099:
2100: -- initialize_solve_object(p_analysis_cycle_id);
2101: zpb_aw.execute('push SV.LN.DIM ');
2102: l_pushed_solve := 'Y';

Line 2170: WHEN FND_API.G_EXC_ERROR THEN

2166: zpb_aw.execute('pop SV.LN.DIM ');
2167: return;
2168:
2169: exception
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO val_gentemp_le_model;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.Count_And_Get(
2174: p_count => x_msg_count,

Line 2172: x_return_status := FND_API.G_RET_STS_ERROR;

2168:
2169: exception
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO val_gentemp_le_model;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173: FND_MSG_PUB.Count_And_Get(
2174: p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );

Line 2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2173: FND_MSG_PUB.Count_And_Get(
2174: p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );
2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2178: ROLLBACK TO val_gentemp_le_model;
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2180: FND_MSG_PUB.Count_And_Get(
2181: p_count => x_msg_count,

Line 2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2175: p_data => x_msg_data
2176: );
2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2178: ROLLBACK TO val_gentemp_le_model;
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2180: FND_MSG_PUB.Count_And_Get(
2181: p_count => x_msg_count,
2182: p_data => x_msg_data
2183: );

Line 2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2182: p_data => x_msg_data
2183: );
2184: WHEN OTHERS THEN
2185: ROLLBACK TO val_gentemp_le_model;
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2187: x_isvalid := 'N';
2188: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2190: FND_MSG_PUB.Add_Exc_Msg(

Line 2214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2210: -- of invalid line member ids if the x_isvalid
2211: -- is equal to 'N' i.e validation failed
2212: PROCEDURE val_solve_input_higher_levels(
2213: p_api_version IN NUMBER,
2214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2217: x_return_status OUT NOCOPY VARCHAR2 ,
2218: x_msg_count OUT NOCOPY NUMBER,

Line 2215: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2211: -- is equal to 'N' i.e validation failed
2212: PROCEDURE val_solve_input_higher_levels(
2213: p_api_version IN NUMBER,
2214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2217: x_return_status OUT NOCOPY VARCHAR2 ,
2218: x_msg_count OUT NOCOPY NUMBER,
2219: x_msg_data OUT NOCOPY VARCHAR2,

Line 2216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2212: PROCEDURE val_solve_input_higher_levels(
2213: p_api_version IN NUMBER,
2214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2217: x_return_status OUT NOCOPY VARCHAR2 ,
2218: x_msg_count OUT NOCOPY NUMBER,
2219: x_msg_data OUT NOCOPY VARCHAR2,
2220: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 2258: IF NOT FND_API.Compatible_API_Call( l_api_version,

2254:
2255: -- Standard Start of API savepoint
2256: SAVEPOINT val_solve_input_higher_levels;
2257: -- Standard call to check for call compatibility.
2258: IF NOT FND_API.Compatible_API_Call( l_api_version,
2259: p_api_version,
2260: l_api_name,
2261: G_PKG_NAME)
2262: THEN

Line 2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2259: p_api_version,
2260: l_api_name,
2261: G_PKG_NAME)
2262: THEN
2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;
2265:
2266: -- Initialize message list if p_init_msg_list is set to TRUE.
2267: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2267: IF FND_API.to_Boolean(p_init_msg_list) THEN

2263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2264: END IF;
2265:
2266: -- Initialize message list if p_init_msg_list is set to TRUE.
2267: IF FND_API.to_Boolean(p_init_msg_list) THEN
2268: FND_MSG_PUB.initialize;
2269: END IF;
2270:
2271: -- Initialize API return status to success

Line 2272: x_return_status := FND_API.G_RET_STS_SUCCESS;

2268: FND_MSG_PUB.initialize;
2269: END IF;
2270:
2271: -- Initialize API return status to success
2272: x_return_status := FND_API.G_RET_STS_SUCCESS;
2273:
2274:
2275: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
2276: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw(fnd_global.user_id);

Line 2335: WHEN FND_API.G_EXC_ERROR THEN

2331: length(x_invalid_linemem_list)-1);
2332: end if;
2333:
2334: exception
2335: WHEN FND_API.G_EXC_ERROR THEN
2336: ROLLBACK TO val_solve_input_higher_levels;
2337: x_return_status := FND_API.G_RET_STS_ERROR;
2338: FND_MSG_PUB.Count_And_Get(
2339: p_count => x_msg_count,

Line 2337: x_return_status := FND_API.G_RET_STS_ERROR;

2333:
2334: exception
2335: WHEN FND_API.G_EXC_ERROR THEN
2336: ROLLBACK TO val_solve_input_higher_levels;
2337: x_return_status := FND_API.G_RET_STS_ERROR;
2338: FND_MSG_PUB.Count_And_Get(
2339: p_count => x_msg_count,
2340: p_data => x_msg_data
2341: );

Line 2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2338: FND_MSG_PUB.Count_And_Get(
2339: p_count => x_msg_count,
2340: p_data => x_msg_data
2341: );
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: ROLLBACK TO val_solve_input_higher_levels;
2344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2345: FND_MSG_PUB.Count_And_Get(
2346: p_count => x_msg_count,

Line 2344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2340: p_data => x_msg_data
2341: );
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: ROLLBACK TO val_solve_input_higher_levels;
2344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2345: FND_MSG_PUB.Count_And_Get(
2346: p_count => x_msg_count,
2347: p_data => x_msg_data
2348: );

Line 2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2347: p_data => x_msg_data
2348: );
2349: WHEN OTHERS THEN
2350: ROLLBACK TO val_solve_input_higher_levels;
2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2352: x_isvalid := 'N';
2353: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2355: FND_MSG_PUB.Add_Exc_Msg(

Line 2369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2365: end val_solve_input_higher_levels;
2366:
2367: PROCEDURE validate_output_selections(
2368: p_api_version IN NUMBER,
2369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2372: x_return_status OUT NOCOPY VARCHAR2 ,
2373: x_msg_count OUT NOCOPY NUMBER,

Line 2370: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2366:
2367: PROCEDURE validate_output_selections(
2368: p_api_version IN NUMBER,
2369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2372: x_return_status OUT NOCOPY VARCHAR2 ,
2373: x_msg_count OUT NOCOPY NUMBER,
2374: x_msg_data OUT NOCOPY VARCHAR2,

Line 2371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2367: PROCEDURE validate_output_selections(
2368: p_api_version IN NUMBER,
2369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2372: x_return_status OUT NOCOPY VARCHAR2 ,
2373: x_msg_count OUT NOCOPY NUMBER,
2374: x_msg_data OUT NOCOPY VARCHAR2,
2375: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 2553: IF NOT FND_API.Compatible_API_Call( l_api_version,

2549: begin
2550: -- Standard Start of API savepoint
2551: SAVEPOINT validate_output_selections;
2552: -- Standard call to check for call compatibility.
2553: IF NOT FND_API.Compatible_API_Call( l_api_version,
2554: p_api_version,
2555: l_api_name,
2556: G_PKG_NAME)
2557: THEN

Line 2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2554: p_api_version,
2555: l_api_name,
2556: G_PKG_NAME)
2557: THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: END IF;
2560:
2561: -- Initialize message list if p_init_msg_list is set to TRUE.
2562: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2562: IF FND_API.to_Boolean(p_init_msg_list) THEN

2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: END IF;
2560:
2561: -- Initialize message list if p_init_msg_list is set to TRUE.
2562: IF FND_API.to_Boolean(p_init_msg_list) THEN
2563: FND_MSG_PUB.initialize;
2564: END IF;
2565:
2566: -- Initialize API return status to success

Line 2567: x_return_status := FND_API.G_RET_STS_SUCCESS;

2563: FND_MSG_PUB.initialize;
2564: END IF;
2565:
2566: -- Initialize API return status to success
2567: x_return_status := FND_API.G_RET_STS_SUCCESS;
2568: x_isvalid := 'Y';
2569: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve output levels');
2570: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw || '!';
2571: l_alldims_invalid := 'N';

Line 2735: WHEN FND_API.G_EXC_ERROR THEN

2731: end if;
2732: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,'Returning :' || x_isvalid);
2733:
2734: exception
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: ROLLBACK TO validate_output_selections;
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: FND_MSG_PUB.Count_And_Get(
2739: p_count => x_msg_count,

Line 2737: x_return_status := FND_API.G_RET_STS_ERROR;

2733:
2734: exception
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: ROLLBACK TO validate_output_selections;
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: FND_MSG_PUB.Count_And_Get(
2739: p_count => x_msg_count,
2740: p_data => x_msg_data
2741: );

Line 2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2738: FND_MSG_PUB.Count_And_Get(
2739: p_count => x_msg_count,
2740: p_data => x_msg_data
2741: );
2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2743: ROLLBACK TO validate_output_selections;
2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2745: FND_MSG_PUB.Count_And_Get(
2746: p_count => x_msg_count,

Line 2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2740: p_data => x_msg_data
2741: );
2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2743: ROLLBACK TO validate_output_selections;
2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2745: FND_MSG_PUB.Count_And_Get(
2746: p_count => x_msg_count,
2747: p_data => x_msg_data
2748: );

Line 2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2747: p_data => x_msg_data
2748: );
2749: WHEN OTHERS THEN
2750: ROLLBACK TO validate_output_selections;
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752: x_isvalid := 'N';
2753: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2754: -- dbms_output.put_line(to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2771: -- x_isvalid: this variable is a boolean and can contain either
2772: -- 'Y' or 'N'
2773: PROCEDURE val_solve_hrzselections(
2774: p_api_version IN NUMBER,
2775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2778: x_return_status OUT NOCOPY VARCHAR2 ,
2779: x_msg_count OUT NOCOPY NUMBER,

Line 2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2772: -- 'Y' or 'N'
2773: PROCEDURE val_solve_hrzselections(
2774: p_api_version IN NUMBER,
2775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2778: x_return_status OUT NOCOPY VARCHAR2 ,
2779: x_msg_count OUT NOCOPY NUMBER,
2780: x_msg_data OUT NOCOPY VARCHAR2,

Line 2777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2773: PROCEDURE val_solve_hrzselections(
2774: p_api_version IN NUMBER,
2775: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2776: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2777: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2778: x_return_status OUT NOCOPY VARCHAR2 ,
2779: x_msg_count OUT NOCOPY NUMBER,
2780: x_msg_data OUT NOCOPY VARCHAR2,
2781: p_analysis_cycle_id IN zpb_analysis_cycles.analysis_cycle_id%type,

Line 2807: IF NOT FND_API.Compatible_API_Call( l_api_version,

2803:
2804: -- Standard Start of API savepoint
2805: SAVEPOINT val_solve_hrzselections;
2806: -- Standard call to check for call compatibility.
2807: IF NOT FND_API.Compatible_API_Call( l_api_version,
2808: p_api_version,
2809: l_api_name,
2810: G_PKG_NAME)
2811: THEN

Line 2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2808: p_api_version,
2809: l_api_name,
2810: G_PKG_NAME)
2811: THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: END IF;
2814:
2815: -- Initialize message list if p_init_msg_list is set to TRUE.
2816: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2816: IF FND_API.to_Boolean(p_init_msg_list) THEN

2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: END IF;
2814:
2815: -- Initialize message list if p_init_msg_list is set to TRUE.
2816: IF FND_API.to_Boolean(p_init_msg_list) THEN
2817: FND_MSG_PUB.initialize;
2818: END IF;
2819:
2820: -- Initialize API return status to success

Line 2821: x_return_status := FND_API.G_RET_STS_SUCCESS;

2817: FND_MSG_PUB.initialize;
2818: END IF;
2819:
2820: -- Initialize API return status to success
2821: x_return_status := FND_API.G_RET_STS_SUCCESS;
2822:
2823: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name,'validating solve levels');
2824: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw||'!';
2825: x_isvalid := 'Y';

Line 2891: WHEN FND_API.G_EXC_ERROR THEN

2887: end if;
2888: close output_selections_cur;
2889:
2890: exception
2891: WHEN FND_API.G_EXC_ERROR THEN
2892: ROLLBACK TO val_solve_hrzselections;
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894: FND_MSG_PUB.Count_And_Get(
2895: p_count => x_msg_count,

Line 2893: x_return_status := FND_API.G_RET_STS_ERROR;

2889:
2890: exception
2891: WHEN FND_API.G_EXC_ERROR THEN
2892: ROLLBACK TO val_solve_hrzselections;
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894: FND_MSG_PUB.Count_And_Get(
2895: p_count => x_msg_count,
2896: p_data => x_msg_data
2897: );

Line 2898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2894: FND_MSG_PUB.Count_And_Get(
2895: p_count => x_msg_count,
2896: p_data => x_msg_data
2897: );
2898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2899: ROLLBACK TO val_solve_hrzselections;
2900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: FND_MSG_PUB.Count_And_Get(
2902: p_count => x_msg_count,

Line 2900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2896: p_data => x_msg_data
2897: );
2898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2899: ROLLBACK TO val_solve_hrzselections;
2900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: FND_MSG_PUB.Count_And_Get(
2902: p_count => x_msg_count,
2903: p_data => x_msg_data
2904: );

Line 2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2903: p_data => x_msg_data
2904: );
2905: WHEN OTHERS THEN
2906: ROLLBACK TO val_solve_hrzselections;
2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2908: x_isvalid := 'N';
2909: -- dbms_output.put_line(to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2910:
2911: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

Line 2958: WHEN FND_API.G_EXC_ERROR THEN

2954:
2955: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, ' View Deleted with Analysis Cycleid' || p_analysis_cycle_id || '.');
2956:
2957: EXCEPTION
2958: WHEN FND_API.G_EXC_ERROR THEN
2959: ROLLBACK TO zpb_acval_pvt_delete_view;
2960: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2961:
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2958: WHEN FND_API.G_EXC_ERROR THEN
2959: ROLLBACK TO zpb_acval_pvt_delete_view;
2960: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2961:
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO zpb_acval_pvt_delete_view;
2964: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2965:
2966: