DBA Data[Home] [Help]

APPS.ZPB_ACVAL_PVT dependencies on FND_MSG_PUB

Line 1358: FND_MSG_PUB.initialize;

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
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1536: FND_MSG_PUB.Count_And_Get(

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: );
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1543: FND_MSG_PUB.Count_And_Get(

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: );
1547: WHEN OTHERS THEN

Line 1553: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1554: FND_MSG_PUB.Add_Exc_Msg(
1555: G_PKG_NAME,
1556: l_api_name
1557: );

Line 1554: FND_MSG_PUB.Add_Exc_Msg(

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
1554: FND_MSG_PUB.Add_Exc_Msg(
1555: G_PKG_NAME,
1556: l_api_name
1557: );
1558: END IF;

Line 1559: FND_MSG_PUB.Count_And_Get(

1555: G_PKG_NAME,
1556: l_api_name
1557: );
1558: END IF;
1559: FND_MSG_PUB.Count_And_Get(
1560: p_count => x_msg_count,
1561: p_data => x_msg_data
1562: );
1563:

Line 1709: FND_MSG_PUB.initialize;

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
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1829: FND_MSG_PUB.Count_And_Get(

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: );
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1836: FND_MSG_PUB.Count_And_Get(

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: );
1840: WHEN OTHERS THEN

Line 1847: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1848: FND_MSG_PUB.Add_Exc_Msg(
1849: G_PKG_NAME,
1850: l_api_name
1851: );

Line 1848: FND_MSG_PUB.Add_Exc_Msg(

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
1848: FND_MSG_PUB.Add_Exc_Msg(
1849: G_PKG_NAME,
1850: l_api_name
1851: );
1852: END IF;

Line 1853: FND_MSG_PUB.Count_And_Get(

1849: G_PKG_NAME,
1850: l_api_name
1851: );
1852: END IF;
1853: FND_MSG_PUB.Count_And_Get(
1854: p_count => x_msg_count,
1855: p_data => x_msg_data
1856: );
1857:

Line 1921: FND_MSG_PUB.initialize;

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
1925: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2007: FND_MSG_PUB.Count_And_Get(

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: );
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2014: FND_MSG_PUB.Count_And_Get(

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: );
2018: WHEN OTHERS THEN

Line 2023: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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(
2025: G_PKG_NAME,
2026: l_api_name
2027: );

Line 2024: FND_MSG_PUB.Add_Exc_Msg(

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(
2025: G_PKG_NAME,
2026: l_api_name
2027: );
2028: END IF;

Line 2029: FND_MSG_PUB.Count_And_Get(

2025: G_PKG_NAME,
2026: l_api_name
2027: );
2028: END IF;
2029: FND_MSG_PUB.Count_And_Get(
2030: p_count => x_msg_count,
2031: p_data => x_msg_data
2032: );
2033:

Line 2094: FND_MSG_PUB.initialize;

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
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2173: FND_MSG_PUB.Count_And_Get(

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: );
2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2180: FND_MSG_PUB.Count_And_Get(

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: );
2184: WHEN OTHERS THEN

Line 2189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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(
2191: G_PKG_NAME,
2192: l_api_name
2193: );

Line 2190: FND_MSG_PUB.Add_Exc_Msg(

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(
2191: G_PKG_NAME,
2192: l_api_name
2193: );
2194: END IF;

Line 2195: FND_MSG_PUB.Count_And_Get(

2191: G_PKG_NAME,
2192: l_api_name
2193: );
2194: END IF;
2195: FND_MSG_PUB.Count_And_Get(
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2198: );
2199:

Line 2268: FND_MSG_PUB.initialize;

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
2272: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2338: FND_MSG_PUB.Count_And_Get(

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: );
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2345: FND_MSG_PUB.Count_And_Get(

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: );
2349: WHEN OTHERS THEN

Line 2354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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(
2356: G_PKG_NAME,
2357: l_api_name
2358: );

Line 2355: FND_MSG_PUB.Add_Exc_Msg(

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(
2356: G_PKG_NAME,
2357: l_api_name
2358: );
2359: END IF;

Line 2360: FND_MSG_PUB.Count_And_Get(

2356: G_PKG_NAME,
2357: l_api_name
2358: );
2359: END IF;
2360: FND_MSG_PUB.Count_And_Get(
2361: p_count => x_msg_count,
2362: p_data => x_msg_data
2363: );
2364:

Line 2563: FND_MSG_PUB.initialize;

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
2567: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2738: FND_MSG_PUB.Count_And_Get(

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: );
2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2745: FND_MSG_PUB.Count_And_Get(

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: );
2749: WHEN OTHERS THEN

Line 2755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
2756: FND_MSG_PUB.Add_Exc_Msg(
2757: G_PKG_NAME,
2758: l_api_name
2759: );

Line 2756: FND_MSG_PUB.Add_Exc_Msg(

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
2756: FND_MSG_PUB.Add_Exc_Msg(
2757: G_PKG_NAME,
2758: l_api_name
2759: );
2760: END IF;

Line 2761: FND_MSG_PUB.Count_And_Get(

2757: G_PKG_NAME,
2758: l_api_name
2759: );
2760: END IF;
2761: FND_MSG_PUB.Count_And_Get(
2762: p_count => x_msg_count,
2763: p_data => x_msg_data
2764: );
2765:

Line 2817: FND_MSG_PUB.initialize;

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
2821: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2894: FND_MSG_PUB.Count_And_Get(

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: );
2898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2901: FND_MSG_PUB.Count_And_Get(

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: );
2905: WHEN OTHERS THEN

Line 2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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));
2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2913: FND_MSG_PUB.Add_Exc_Msg(
2914: G_PKG_NAME,
2915: l_api_name
2916: );

Line 2913: FND_MSG_PUB.Add_Exc_Msg(

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));
2912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2913: FND_MSG_PUB.Add_Exc_Msg(
2914: G_PKG_NAME,
2915: l_api_name
2916: );
2917: END IF;

Line 2918: FND_MSG_PUB.Count_And_Get(

2914: G_PKG_NAME,
2915: l_api_name
2916: );
2917: END IF;
2918: FND_MSG_PUB.Count_And_Get(
2919: p_count => x_msg_count,
2920: p_data => x_msg_data
2921: );
2922: