[Home] [Help]
1826: AND function_name = pFunctionName
1827: AND user_id = pUserId
1828: AND schedule_id IS NULL;
1829:
1830: x_return_status := FND_API.G_RET_STS_SUCCESS;
1831: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
1832: , p_data => x_msg_data);
1833:
1834: EXCEPTION
1831: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count
1832: , p_data => x_msg_data);
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: , p_data => x_msg_data);
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1841: WHEN OTHERS THEN
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1841: WHEN OTHERS THEN
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1841: WHEN OTHERS THEN
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1844: END COPY_SES_TO_DEF_PARAMETERS;
1845:
1846: /* This procedure is based on validate_and_save */
1879: end if;
1880:
1881:
1882: EXCEPTION
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880:
1881:
1882: EXCEPTION
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1882: EXCEPTION
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1889: WHEN OTHERS THEN
1890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1883: WHEN FND_API.G_EXC_ERROR THEN
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1889: WHEN OTHERS THEN
1890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1891: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1889: WHEN OTHERS THEN
1890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1891: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1892:
1893: END VALIDATE_PARAMETER;
1894:
1944: ,x_msg_count => x_msg_count
1945: ,x_msg_data => x_msg_data);
1946: END IF;
1947: EXCEPTION
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: ,x_msg_data => x_msg_data);
1946: END IF;
1947: EXCEPTION
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1947: EXCEPTION
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1954: WHEN OTHERS THEN
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1954: WHEN OTHERS THEN
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1954: WHEN OTHERS THEN
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
1957: END VALIDATE_AND_SAVE;
1958:
1959: PROCEDURE VALIDATE_AND_SAVE_TIME
2028: ,x_msg_count => x_msg_count
2029: ,x_msg_data => x_msg_data);
2030: END IF;
2031: EXCEPTION
2032: WHEN FND_API.G_EXC_ERROR THEN
2033: x_return_status := FND_API.G_RET_STS_ERROR;
2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2029: ,x_msg_data => x_msg_data);
2030: END IF;
2031: EXCEPTION
2032: WHEN FND_API.G_EXC_ERROR THEN
2033: x_return_status := FND_API.G_RET_STS_ERROR;
2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2031: EXCEPTION
2032: WHEN FND_API.G_EXC_ERROR THEN
2033: x_return_status := FND_API.G_RET_STS_ERROR;
2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2038: WHEN OTHERS THEN
2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: WHEN FND_API.G_EXC_ERROR THEN
2033: x_return_status := FND_API.G_RET_STS_ERROR;
2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2038: WHEN OTHERS THEN
2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2040: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2038: WHEN OTHERS THEN
2039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2040: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2041: END VALIDATE_AND_SAVE_TIME;
2042:
2043: PROCEDURE VALIDATE_NONTIME_PARAMETER
2067: IF p_parameter_rec.hierarchy_flag = 'Y' THEN
2068:
2069: IF p_parameter_rec.parameter_value IS NULL THEN
2070: x_valid := 'N';
2071: RAISE FND_API.G_EXC_ERROR;
2072: END IF;
2073:
2074: ELSE
2075: --aleung, 7/17/02, validation through id instead of value
2090: FND_MESSAGE.SET_NAME('BIS','MANDATORY_PARAM');
2091: --Need to add a message token later
2092: FND_MESSAGE.SET_TOKEN('PARAMETER_LABEL', p_parameter_rec.parameter_label);
2093: FND_MSG_PUB.ADD;
2094: RAISE FND_API.G_EXC_ERROR;
2095: END IF;
2096: --BugFix 3497180, Fix for Rolling Dimension Validation
2097: IF c_rolling_dim%ISOPEN THEN
2098: CLOSE c_rolling_dim;
2148: FND_MESSAGE.SET_NAME('BIS','NOT_VALID');
2149: --Need to add a message token later
2150: FND_MESSAGE.SET_TOKEN('PARAMETER_LABEL', p_parameter_rec.parameter_label);
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154: END IF;
2155: ELSE
2156: p_parameter_rec.parameter_value := p_parameter_rec.parameter_description;
2163: IF p_parameter_rec.parameter_description IS NULL THEN
2164: x_valid := 'N';
2165: FND_MESSAGE.SET_NAME('BIS','INVALID_VIEWBY');
2166: FND_MSG_PUB.ADD;
2167: RAISE FND_API.G_EXC_ERROR;
2168: ELSE
2169: p_parameter_rec.parameter_value := p_parameter_rec.parameter_description;
2170: END IF;
2171: ELSIF p_parameter_rec.parameter_name = 'BUSINESS_PLAN' then
2197: p_parameter_rec.parameter_value = g_all THEN
2198: p_parameter_rec.parameter_value := null;
2199: END IF;
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198: p_parameter_rec.parameter_value := null;
2199: END IF;
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2207: WHEN OTHERS THEN
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2207: WHEN OTHERS THEN
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2207: WHEN OTHERS THEN
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2210: END VALIDATE_NONTIME_PARAMETER;
2211:
2212: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
2348: FND_MESSAGE.SET_NAME('BIS','MANDATORY_PARAM');
2349: --Need to add a message token later
2350: FND_MESSAGE.SET_TOKEN('PARAMETER_LABEL', p_time_parameter_rec.parameter_label);
2351: FND_MSG_PUB.ADD;
2352: RAISE FND_API.G_EXC_ERROR;
2353: END IF;
2354:
2355: IF nvl(p_time_parameter_rec.from_description, g_all) <> g_all THEN
2356: if p_time_parameter_rec.id_flag = 'Y' then
2389: FND_MESSAGE.SET_NAME('BIS','NOT_VALID');
2390: --Need to add a message token later
2391: FND_MESSAGE.SET_TOKEN('PARAMETER_LABEL', p_time_parameter_rec.parameter_label);
2392: FND_MSG_PUB.ADD;
2393: RAISE FND_API.G_EXC_ERROR;
2394: END IF;
2395: END IF;
2396:
2397: IF nvl(p_time_parameter_rec.to_description, g_all) <> g_all THEN
2431: FND_MESSAGE.SET_NAME('BIS','NOT_VALID');
2432: --Need to add a message token later
2433: FND_MESSAGE.SET_TOKEN('PARAMETER_LABEL', p_time_parameter_rec.parameter_label);
2434: FND_MSG_PUB.ADD;
2435: RAISE FND_API.G_EXC_ERROR;
2436: END IF;
2437: END IF;
2438: EXCEPTION
2439: WHEN FND_API.G_EXC_ERROR THEN
2435: RAISE FND_API.G_EXC_ERROR;
2436: END IF;
2437: END IF;
2438: EXCEPTION
2439: WHEN FND_API.G_EXC_ERROR THEN
2440: x_return_status := FND_API.G_RET_STS_ERROR;
2441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: END IF;
2437: END IF;
2438: EXCEPTION
2439: WHEN FND_API.G_EXC_ERROR THEN
2440: x_return_status := FND_API.G_RET_STS_ERROR;
2441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2438: EXCEPTION
2439: WHEN FND_API.G_EXC_ERROR THEN
2440: x_return_status := FND_API.G_RET_STS_ERROR;
2441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2445: WHEN OTHERS THEN
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2439: WHEN FND_API.G_EXC_ERROR THEN
2440: x_return_status := FND_API.G_RET_STS_ERROR;
2441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2445: WHEN OTHERS THEN
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2445: WHEN OTHERS THEN
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2448: END VALIDATE_TIME_PARAMETER;
2449:
2450: PROCEDURE DECODE_ID_VALUE
2546:
2547: END IF;
2548: END IF;
2549: EXCEPTION
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: x_return_status := FND_API.G_RET_STS_ERROR;
2552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547: END IF;
2548: END IF;
2549: EXCEPTION
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: x_return_status := FND_API.G_RET_STS_ERROR;
2552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2549: EXCEPTION
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: x_return_status := FND_API.G_RET_STS_ERROR;
2552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2556: WHEN OTHERS THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: x_return_status := FND_API.G_RET_STS_ERROR;
2552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2556: WHEN OTHERS THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2555: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2556: WHEN OTHERS THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2559: END CREATE_PARAMETER;
2560:
2561: PROCEDURE RETRIEVE_PARAMETER
2601: AND session_id = p_user_session_rec.session_id
2602: AND schedule_id IS NULL;
2603: END IF;
2604: EXCEPTION
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: x_return_status := FND_API.G_RET_STS_ERROR;
2607: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2602: AND schedule_id IS NULL;
2603: END IF;
2604: EXCEPTION
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: x_return_status := FND_API.G_RET_STS_ERROR;
2607: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2604: EXCEPTION
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: x_return_status := FND_API.G_RET_STS_ERROR;
2607: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2611: WHEN OTHERS THEN
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: WHEN FND_API.G_EXC_ERROR THEN
2606: x_return_status := FND_API.G_RET_STS_ERROR;
2607: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2611: WHEN OTHERS THEN
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2613: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2611: WHEN OTHERS THEN
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2613: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2614: END RETRIEVE_PARAMETER;
2615:
2616: PROCEDURE RETRIEVE_PAGE_PARAMETER
2632: l_page_dims(i) := NULL;
2633: END LOOP;
2634: END IF;
2635:
2636: x_return_status := FND_API.G_RET_STS_SUCCESS;
2637: BEGIN
2638: SELECT session_description,
2639: session_value,
2640: period_date,
2725: end if;
2726: end if;
2727: END;
2728: EXCEPTION
2729: WHEN FND_API.G_EXC_ERROR THEN
2730: x_return_status := FND_API.G_RET_STS_ERROR;
2731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726: end if;
2727: END;
2728: EXCEPTION
2729: WHEN FND_API.G_EXC_ERROR THEN
2730: x_return_status := FND_API.G_RET_STS_ERROR;
2731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2728: EXCEPTION
2729: WHEN FND_API.G_EXC_ERROR THEN
2730: x_return_status := FND_API.G_RET_STS_ERROR;
2731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2735: WHEN OTHERS THEN
2736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2729: WHEN FND_API.G_EXC_ERROR THEN
2730: x_return_status := FND_API.G_RET_STS_ERROR;
2731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2735: WHEN OTHERS THEN
2736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2737: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2735: WHEN OTHERS THEN
2736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2737: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2738: END RETRIEVE_PAGE_PARAMETER;
2739:
2740: PROCEDURE RETRIEVE_KPI_PARAMETER
2749: l_user_dims BISVIEWER.t_char := p_user_dims;
2750:
2751: BEGIN
2752:
2753: x_return_status := FND_API.G_RET_STS_SUCCESS;
2754:
2755: -- make sure there are max elements as they will be accessed
2756: IF l_user_dims IS NOT NULL AND l_user_dims.COUNT < MAX_BIND_VARIABLE_COUNT THEN
2757: FOR i IN l_user_dims.COUNT .. MAX_BIND_VARIABLE_COUNT LOOP
2813: AND page_id = p_user_session_rec.page_id;
2814: end if;
2815: END;
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814: end if;
2815: END;
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2816: EXCEPTION
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2823: WHEN OTHERS THEN
2824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2817: WHEN FND_API.G_EXC_ERROR THEN
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2823: WHEN OTHERS THEN
2824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2825: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2823: WHEN OTHERS THEN
2824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2825: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2826: END RETRIEVE_KPI_PARAMETER;
2827:
2828: PROCEDURE RETRIEVE_SCHEDULE_PARAMETER
2846: FROM BIS_USER_ATTRIBUTES
2847: WHERE attribute_name = p_parameter_rec.parameter_name
2848: AND schedule_id = p_schedule_id;
2849: EXCEPTION
2850: WHEN FND_API.G_EXC_ERROR THEN
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2847: WHERE attribute_name = p_parameter_rec.parameter_name
2848: AND schedule_id = p_schedule_id;
2849: EXCEPTION
2850: WHEN FND_API.G_EXC_ERROR THEN
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2849: EXCEPTION
2850: WHEN FND_API.G_EXC_ERROR THEN
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2856: WHEN OTHERS THEN
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2850: WHEN FND_API.G_EXC_ERROR THEN
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2856: WHEN OTHERS THEN
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2855: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2856: WHEN OTHERS THEN
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2859: END RETRIEVE_SCHEDULE_PARAMETER;
2860:
2861: PROCEDURE DELETE_PARAMETER
2889: AND attribute_name = p_parameter_name;
2890: END IF;
2891: COMMIT;
2892: EXCEPTION
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: ROLLBACK;
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: COMMIT;
2892: EXCEPTION
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: ROLLBACK;
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2898: ROLLBACK;
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: ROLLBACK;
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2898: ROLLBACK;
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2900: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2901: WHEN OTHERS THEN
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2898: ROLLBACK;
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2900: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2901: WHEN OTHERS THEN
2902: ROLLBACK;
2903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2900: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2901: WHEN OTHERS THEN
2902: ROLLBACK;
2903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2904: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2905: END DELETE_PARAMETER;
2906:
2907: PROCEDURE DELETE_SCHEDULE_PARAMETER
2916: WHERE attribute_name = p_parameter_name
2917: AND schedule_id = p_schedule_id;
2918: COMMIT;
2919: EXCEPTION
2920: WHEN FND_API.G_EXC_ERROR THEN
2921: ROLLBACK;
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2918: COMMIT;
2919: EXCEPTION
2920: WHEN FND_API.G_EXC_ERROR THEN
2921: ROLLBACK;
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925: ROLLBACK;
2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2920: WHEN FND_API.G_EXC_ERROR THEN
2921: ROLLBACK;
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925: ROLLBACK;
2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2927: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2928: WHEN OTHERS THEN
2922: x_return_status := FND_API.G_RET_STS_ERROR;
2923: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925: ROLLBACK;
2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2927: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2928: WHEN OTHERS THEN
2929: ROLLBACK;
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2927: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2928: WHEN OTHERS THEN
2929: ROLLBACK;
2930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2932: END DELETE_SCHEDULE_PARAMETER;
2933:
2934: PROCEDURE CREATE_SESSION_PARAMETERS
2993: ,x_msg_Data => x_msg_data
2994: );
2995: END IF; -- if rolling dim
2996:
2997: IF (x_return_status is not null OR (x_return_status <> FND_API.G_RET_STS_SUCCESS))THEN
2998: EXIT;
2999: END IF;
3000:
3001: END IF; -- if param name is not null
3001: END IF; -- if param name is not null
3002: END LOOP;
3003: END IF;
3004: EXCEPTION
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: ROLLBACK;
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3003: END IF;
3004: EXCEPTION
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: ROLLBACK;
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: ROLLBACK;
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: ROLLBACK;
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: ROLLBACK;
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3013: WHEN OTHERS THEN
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: ROLLBACK;
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3013: WHEN OTHERS THEN
3014: ROLLBACK;
3015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3013: WHEN OTHERS THEN
3014: ROLLBACK;
3015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3016: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3017: END CREATE_SESSION_PARAMETERS;
3018:
3019: PROCEDURE RETRIEVE_PAGE_PARAMETERS
3116: END LOOP;
3117: END IF;
3118:
3119: EXCEPTION
3120: WHEN FND_API.G_EXC_ERROR THEN
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3117: END IF;
3118:
3119: EXCEPTION
3120: WHEN FND_API.G_EXC_ERROR THEN
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3119: EXCEPTION
3120: WHEN FND_API.G_EXC_ERROR THEN
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3126: WHEN OTHERS THEN
3127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3120: WHEN FND_API.G_EXC_ERROR THEN
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3126: WHEN OTHERS THEN
3127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3126: WHEN OTHERS THEN
3127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3129: END RETRIEVE_PAGE_PARAMETERS;
3130:
3131: PROCEDURE RETRIEVE_KPI_PARAMETERS
3198: l_index := l_index + 1;
3199: END LOOP;
3200:
3201: EXCEPTION
3202: WHEN FND_API.G_EXC_ERROR THEN
3203: x_return_status := FND_API.G_RET_STS_ERROR;
3204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3199: END LOOP;
3200:
3201: EXCEPTION
3202: WHEN FND_API.G_EXC_ERROR THEN
3203: x_return_status := FND_API.G_RET_STS_ERROR;
3204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3201: EXCEPTION
3202: WHEN FND_API.G_EXC_ERROR THEN
3203: x_return_status := FND_API.G_RET_STS_ERROR;
3204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3208: WHEN OTHERS THEN
3209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202: WHEN FND_API.G_EXC_ERROR THEN
3203: x_return_status := FND_API.G_RET_STS_ERROR;
3204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3208: WHEN OTHERS THEN
3209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3208: WHEN OTHERS THEN
3209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3211: END RETRIEVE_KPI_PARAMETERS;
3212:
3213: PROCEDURE RETRIEVE_PARAMLVL_PARAMETERS
3230: ,p_page_dims => lNullList
3231: ,x_return_status => x_return_status
3232: ,x_msg_count => x_msg_count
3233: ,x_msg_data => x_msg_data);
3234: IF (x_return_status is null or x_return_status = FND_API.G_RET_STS_SUCCESS) then
3235: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3236: l_index := l_index + 1;
3237: end if;
3238: l_parameter_rec.parameter_name := 'BIS_P_ASOF_DATE';
3242: ,p_page_dims => lNullList
3243: ,x_return_status => x_return_status
3244: ,x_msg_count => x_msg_count
3245: ,x_msg_data => x_msg_data);
3246: IF (x_return_status is null or x_return_status = FND_API.G_RET_STS_SUCCESS) then
3247: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3248: l_index := l_index + 1;
3249: end if;
3250: l_parameter_rec.parameter_name := 'BIS_CUR_REPORT_START_DATE';
3254: ,p_page_dims => lNullList
3255: ,x_return_status => x_return_status
3256: ,x_msg_count => x_msg_count
3257: ,x_msg_data => x_msg_data);
3258: IF (x_return_status is null or x_return_status = FND_API.G_RET_STS_SUCCESS) then
3259: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3260: l_index := l_index + 1;
3261: end if;
3262: l_parameter_rec.parameter_name := 'BIS_PREV_REPORT_START_DATE';
3266: ,p_page_dims => lNullList
3267: ,x_return_status => x_return_status
3268: ,x_msg_count => x_msg_count
3269: ,x_msg_data => x_msg_data);
3270: IF (x_return_status is null or x_return_status = FND_API.G_RET_STS_SUCCESS) then
3271: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3272: l_index := l_index + 1;
3273: end if;
3274: -- nbarik - 07/17/03 - Bug Fix 2999602 - Added BIS_PREVIOUS_EFFECTIVE_START_DATE and BIS_PREVIOUS_EFFECTIVE_END_DATE
3279: ,p_page_dims => lNullList
3280: ,x_return_status => x_return_status
3281: ,x_msg_count => x_msg_count
3282: ,x_msg_data => x_msg_data);
3283: IF (x_return_status is null or x_return_status = FND_API.G_RET_STS_SUCCESS) then
3284: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3285: l_index := l_index + 1;
3286: end if;
3287: l_parameter_rec.parameter_name := 'BIS_PREVIOUS_EFFECTIVE_END_DATE';
3291: ,p_page_dims => lNullList
3292: ,x_return_status => x_return_status
3293: ,x_msg_count => x_msg_count
3294: ,x_msg_data => x_msg_data);
3295: IF (x_return_status is null or x_return_status = FND_API.G_RET_STS_SUCCESS) then
3296: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3297: l_index := l_index + 1;
3298: end if;
3299:
3316: AND page_id = p_user_session_rec.page_id;
3317: END;
3318: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3319: EXCEPTION
3320: WHEN FND_API.G_EXC_ERROR THEN
3321: x_return_status := FND_API.G_RET_STS_ERROR;
3322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3317: END;
3318: x_paramportlet_param_tbl(l_index) := l_parameter_rec;
3319: EXCEPTION
3320: WHEN FND_API.G_EXC_ERROR THEN
3321: x_return_status := FND_API.G_RET_STS_ERROR;
3322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3319: EXCEPTION
3320: WHEN FND_API.G_EXC_ERROR THEN
3321: x_return_status := FND_API.G_RET_STS_ERROR;
3322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3326: WHEN OTHERS THEN
3327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3320: WHEN FND_API.G_EXC_ERROR THEN
3321: x_return_status := FND_API.G_RET_STS_ERROR;
3322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3326: WHEN OTHERS THEN
3327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3328: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3325: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3326: WHEN OTHERS THEN
3327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3328: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3329:
3330: END;
3331:
3383: l_index := l_index + 1;
3384: END LOOP;
3385:
3386: EXCEPTION
3387: WHEN FND_API.G_EXC_ERROR THEN
3388: x_return_status := FND_API.G_RET_STS_ERROR;
3389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3384: END LOOP;
3385:
3386: EXCEPTION
3387: WHEN FND_API.G_EXC_ERROR THEN
3388: x_return_status := FND_API.G_RET_STS_ERROR;
3389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3392: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3386: EXCEPTION
3387: WHEN FND_API.G_EXC_ERROR THEN
3388: x_return_status := FND_API.G_RET_STS_ERROR;
3389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3392: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3393: WHEN OTHERS THEN
3394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3387: WHEN FND_API.G_EXC_ERROR THEN
3388: x_return_status := FND_API.G_RET_STS_ERROR;
3389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3392: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3393: WHEN OTHERS THEN
3394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3395: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3392: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3393: WHEN OTHERS THEN
3394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3395: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3396: END RETRIEVE_SCHEDULE_PARAMETERS;
3397:
3398: PROCEDURE RETRIEVE_SESSION_PARAMETERS
3455: l_index := l_index + 1;
3456: END LOOP;
3457:
3458: EXCEPTION
3459: WHEN FND_API.G_EXC_ERROR THEN
3460: x_return_status := FND_API.G_RET_STS_ERROR;
3461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3456: END LOOP;
3457:
3458: EXCEPTION
3459: WHEN FND_API.G_EXC_ERROR THEN
3460: x_return_status := FND_API.G_RET_STS_ERROR;
3461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3458: EXCEPTION
3459: WHEN FND_API.G_EXC_ERROR THEN
3460: x_return_status := FND_API.G_RET_STS_ERROR;
3461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3465: WHEN OTHERS THEN
3466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3459: WHEN FND_API.G_EXC_ERROR THEN
3460: x_return_status := FND_API.G_RET_STS_ERROR;
3461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3465: WHEN OTHERS THEN
3466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3465: WHEN OTHERS THEN
3466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3468: END RETRIEVE_SESSION_PARAMETERS;
3469:
3470: PROCEDURE RETRIEVE_DEFAULT_PARAMETERS
3527: l_index := l_index + 1;
3528: END LOOP;
3529:
3530: EXCEPTION
3531: WHEN FND_API.G_EXC_ERROR THEN
3532: x_return_status := FND_API.G_RET_STS_ERROR;
3533: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3528: END LOOP;
3529:
3530: EXCEPTION
3531: WHEN FND_API.G_EXC_ERROR THEN
3532: x_return_status := FND_API.G_RET_STS_ERROR;
3533: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3536: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3530: EXCEPTION
3531: WHEN FND_API.G_EXC_ERROR THEN
3532: x_return_status := FND_API.G_RET_STS_ERROR;
3533: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3536: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3537: WHEN OTHERS THEN
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3531: WHEN FND_API.G_EXC_ERROR THEN
3532: x_return_status := FND_API.G_RET_STS_ERROR;
3533: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3536: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3537: WHEN OTHERS THEN
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3536: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3537: WHEN OTHERS THEN
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3540: END RETRIEVE_DEFAULT_PARAMETERS;
3541:
3542: PROCEDURE DELETE_SESSION_PARAMETERS
3566: AND function_name = p_user_session_rec.function_name;
3567: END IF;
3568: COMMIT;
3569: EXCEPTION
3570: WHEN FND_API.G_EXC_ERROR THEN
3571: x_return_status := FND_API.G_RET_STS_ERROR;
3572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3567: END IF;
3568: COMMIT;
3569: EXCEPTION
3570: WHEN FND_API.G_EXC_ERROR THEN
3571: x_return_status := FND_API.G_RET_STS_ERROR;
3572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3569: EXCEPTION
3570: WHEN FND_API.G_EXC_ERROR THEN
3571: x_return_status := FND_API.G_RET_STS_ERROR;
3572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3576: WHEN OTHERS THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3570: WHEN FND_API.G_EXC_ERROR THEN
3571: x_return_status := FND_API.G_RET_STS_ERROR;
3572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3576: WHEN OTHERS THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3576: WHEN OTHERS THEN
3577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3579: END DELETE_SESSION_PARAMETERS;
3580:
3581: PROCEDURE DELETE_PAGE_PARAMETERS
3590: WHERE user_id = p_user_session_rec.user_id
3591: AND page_id = p_user_session_rec.page_id;
3592: COMMIT;
3593: EXCEPTION
3594: WHEN FND_API.G_EXC_ERROR THEN
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3591: AND page_id = p_user_session_rec.page_id;
3592: COMMIT;
3593: EXCEPTION
3594: WHEN FND_API.G_EXC_ERROR THEN
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3599: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3593: EXCEPTION
3594: WHEN FND_API.G_EXC_ERROR THEN
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3599: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3600: WHEN OTHERS THEN
3601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3594: WHEN FND_API.G_EXC_ERROR THEN
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3599: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3600: WHEN OTHERS THEN
3601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3602: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3599: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3600: WHEN OTHERS THEN
3601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3602: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3603:
3604: END DELETE_PAGE_PARAMETERS;
3605:
3616: function_name = p_user_session_rec.function_name
3617: AND user_id=p_user_session_rec.user_id;
3618: COMMIT;
3619: EXCEPTION
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3617: AND user_id=p_user_session_rec.user_id;
3618: COMMIT;
3619: EXCEPTION
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3619: EXCEPTION
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3626: WHEN OTHERS THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3626: WHEN OTHERS THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3628: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3626: WHEN OTHERS THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3628: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3629:
3630: END DELETE_DEFAULT_PARAMETERS;
3631:
3639: DELETE FROM BIS_USER_ATTRIBUTES
3640: WHERE schedule_id = p_schedule_id;
3641: COMMIT;
3642: EXCEPTION
3643: WHEN FND_API.G_EXC_ERROR THEN
3644: ROLLBACK;
3645: x_return_status := FND_API.G_RET_STS_ERROR;
3646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3641: COMMIT;
3642: EXCEPTION
3643: WHEN FND_API.G_EXC_ERROR THEN
3644: ROLLBACK;
3645: x_return_status := FND_API.G_RET_STS_ERROR;
3646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3648: ROLLBACK;
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3643: WHEN FND_API.G_EXC_ERROR THEN
3644: ROLLBACK;
3645: x_return_status := FND_API.G_RET_STS_ERROR;
3646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3648: ROLLBACK;
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3651: WHEN OTHERS THEN
3645: x_return_status := FND_API.G_RET_STS_ERROR;
3646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3648: ROLLBACK;
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3651: WHEN OTHERS THEN
3652: ROLLBACK;
3653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3651: WHEN OTHERS THEN
3652: ROLLBACK;
3653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3654: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3655: END DELETE_SCHEDULE_PARAMETERS;
3656:
3657: PROCEDURE GET_NONTIME_VALIDATED_VALUE
3720:
3721: x_parameter_value := substr(v_dimn_level_value_id, 2);
3722:
3723: EXCEPTION
3724: WHEN FND_API.G_EXC_ERROR THEN
3725: x_return_status := FND_API.G_RET_STS_ERROR;
3726: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3721: x_parameter_value := substr(v_dimn_level_value_id, 2);
3722:
3723: EXCEPTION
3724: WHEN FND_API.G_EXC_ERROR THEN
3725: x_return_status := FND_API.G_RET_STS_ERROR;
3726: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3729: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3723: EXCEPTION
3724: WHEN FND_API.G_EXC_ERROR THEN
3725: x_return_status := FND_API.G_RET_STS_ERROR;
3726: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3729: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3730: WHEN OTHERS THEN
3731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3724: WHEN FND_API.G_EXC_ERROR THEN
3725: x_return_status := FND_API.G_RET_STS_ERROR;
3726: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3729: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3730: WHEN OTHERS THEN
3731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3732: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3729: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3730: WHEN OTHERS THEN
3731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3732: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3733: END GET_NONTIME_VALIDATED_VALUE;
3734:
3735: PROCEDURE GET_NONTIME_VALIDATED_ID
3796: ,x_msg_data => x_msg_data
3797: );
3798:
3799: EXCEPTION
3800: WHEN FND_API.G_EXC_ERROR THEN
3801: x_return_status := FND_API.G_RET_STS_ERROR;
3802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3797: );
3798:
3799: EXCEPTION
3800: WHEN FND_API.G_EXC_ERROR THEN
3801: x_return_status := FND_API.G_RET_STS_ERROR;
3802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3805: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3799: EXCEPTION
3800: WHEN FND_API.G_EXC_ERROR THEN
3801: x_return_status := FND_API.G_RET_STS_ERROR;
3802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3805: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3806: WHEN OTHERS THEN
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3800: WHEN FND_API.G_EXC_ERROR THEN
3801: x_return_status := FND_API.G_RET_STS_ERROR;
3802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3805: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3806: WHEN OTHERS THEN
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3805: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3806: WHEN OTHERS THEN
3807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3809: END GET_NONTIME_VALIDATED_ID;
3810:
3811: PROCEDURE GET_TIME_VALIDATED_VALUE
3872: ,x_msg_data => x_msg_data
3873: );
3874:
3875: EXCEPTION
3876: WHEN FND_API.G_EXC_ERROR THEN
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3873: );
3874:
3875: EXCEPTION
3876: WHEN FND_API.G_EXC_ERROR THEN
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3881: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3875: EXCEPTION
3876: WHEN FND_API.G_EXC_ERROR THEN
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3881: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3882: WHEN OTHERS THEN
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3876: WHEN FND_API.G_EXC_ERROR THEN
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3881: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3882: WHEN OTHERS THEN
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3884: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3881: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3882: WHEN OTHERS THEN
3883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3884: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3885: END GET_TIME_VALIDATED_VALUE;
3886:
3887: PROCEDURE GET_TIME_VALIDATED_ID
3950: ,x_msg_data => x_msg_data
3951: );
3952:
3953: EXCEPTION
3954: WHEN FND_API.G_EXC_ERROR THEN
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3951: );
3952:
3953: EXCEPTION
3954: WHEN FND_API.G_EXC_ERROR THEN
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3959: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3953: EXCEPTION
3954: WHEN FND_API.G_EXC_ERROR THEN
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3959: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3954: WHEN FND_API.G_EXC_ERROR THEN
3955: x_return_status := FND_API.G_RET_STS_ERROR;
3956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3959: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3962: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3959: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3962: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3963: END GET_TIME_VALIDATED_ID;
3964:
3965: PROCEDURE GET_TIME_INFO
4020: end loop;
4021: close c1;
4022:
4023: EXCEPTION
4024: WHEN FND_API.G_EXC_ERROR THEN
4025: x_return_status := FND_API.G_RET_STS_ERROR;
4026: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4021: close c1;
4022:
4023: EXCEPTION
4024: WHEN FND_API.G_EXC_ERROR THEN
4025: x_return_status := FND_API.G_RET_STS_ERROR;
4026: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4023: EXCEPTION
4024: WHEN FND_API.G_EXC_ERROR THEN
4025: x_return_status := FND_API.G_RET_STS_ERROR;
4026: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4030: WHEN OTHERS THEN
4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4024: WHEN FND_API.G_EXC_ERROR THEN
4025: x_return_status := FND_API.G_RET_STS_ERROR;
4026: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4030: WHEN OTHERS THEN
4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4030: WHEN OTHERS THEN
4031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4033: END GET_TIME_INFO;
4034:
4035: PROCEDURE getLOVSQL
4203: */
4204:
4205: v_bind_sql := v_sql_stmnt;
4206:
4207: if v_return_status = FND_API.G_RET_STS_ERROR then
4208: for i in 1..v_msg_count loop
4209: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
4210: end loop;
4211: end if;
4205: v_bind_sql := v_sql_stmnt;
4206:
4207: if v_return_status = FND_API.G_RET_STS_ERROR then
4208: for i in 1..v_msg_count loop
4209: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
4210: end loop;
4211: end if;
4212:
4213: if (upper(nvl(p_parameter_description, G_ALL)) <> upper(G_ALL) AND trim(p_parameter_description) <> '%') then
4339: x_bind_variables := v_bind_variables;
4340: x_bind_count := v_bind_count;
4341:
4342: EXCEPTION
4343: WHEN FND_API.G_EXC_ERROR THEN
4344: x_return_status := FND_API.G_RET_STS_ERROR;
4345: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4340: x_bind_count := v_bind_count;
4341:
4342: EXCEPTION
4343: WHEN FND_API.G_EXC_ERROR THEN
4344: x_return_status := FND_API.G_RET_STS_ERROR;
4345: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4342: EXCEPTION
4343: WHEN FND_API.G_EXC_ERROR THEN
4344: x_return_status := FND_API.G_RET_STS_ERROR;
4345: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4349: WHEN OTHERS THEN
4350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4343: WHEN FND_API.G_EXC_ERROR THEN
4344: x_return_status := FND_API.G_RET_STS_ERROR;
4345: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4349: WHEN OTHERS THEN
4350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4351: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4349: WHEN OTHERS THEN
4350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4351: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4352: END getLOVSQL;
4353:
4354: PROCEDURE getTimeLovSql
4503: ,x_msg_count=> v_msg_count
4504: ,x_msg_data=> v_msg_data
4505: );
4506: --end if;
4507: if v_return_status = FND_API.G_RET_STS_ERROR then
4508: for i in 1..v_msg_count loop
4509: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
4510: end loop;
4511: end if;
4505: );
4506: --end if;
4507: if v_return_status = FND_API.G_RET_STS_ERROR then
4508: for i in 1..v_msg_count loop
4509: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
4510: end loop;
4511: end if;
4512:
4513: if rtrim(ltrim(vEdwDimensionLevel)) = 'EDW_TIME_A' then
4613: ,x_msg_count=> v_msg_count
4614: ,x_msg_data=> v_msg_data
4615: );
4616:
4617: if v_return_status = FND_API.G_RET_STS_ERROR then
4618: for i in 1..v_msg_count loop
4619: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
4620: end loop;
4621: end if;
4615: );
4616:
4617: if v_return_status = FND_API.G_RET_STS_ERROR then
4618: for i in 1..v_msg_count loop
4619: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
4620: end loop;
4621: end if;
4622: end if;
4623:
4739:
4740: end if;
4741:
4742: EXCEPTION
4743: WHEN FND_API.G_EXC_ERROR THEN
4744: x_return_status := FND_API.G_RET_STS_ERROR;
4745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4740: end if;
4741:
4742: EXCEPTION
4743: WHEN FND_API.G_EXC_ERROR THEN
4744: x_return_status := FND_API.G_RET_STS_ERROR;
4745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4742: EXCEPTION
4743: WHEN FND_API.G_EXC_ERROR THEN
4744: x_return_status := FND_API.G_RET_STS_ERROR;
4745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4749: WHEN OTHERS THEN
4750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4743: WHEN FND_API.G_EXC_ERROR THEN
4744: x_return_status := FND_API.G_RET_STS_ERROR;
4745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4749: WHEN OTHERS THEN
4750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4751: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4749: WHEN OTHERS THEN
4750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4751: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
4752: END getTimeLovSql;
4753:
4754: procedure saveParameters
5408: ,x_return_Status => x_return_Status
5409: ,x_msg_count => x_msg_count
5410: ,x_msg_Data => x_msg_Data);
5411:
5412: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5413: RETURN;
5414: END IF;
5415:
5416:
5457: ,p_parameter_rec => l_parameter_rec
5458: ,x_return_status => x_return_status
5459: ,x_msg_count => x_msg_count
5460: ,x_msg_data => x_msg_data);
5461: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5462: RETURN;
5463: END IF;
5464: END IF;
5465:
5487: x_return_status => x_return_status,
5488: x_msg_count => x_msg_count,
5489: x_msg_Data => x_msg_Data
5490: );
5491: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5492: RETURN;
5493: END IF;
5494:
5495: l_parameter_rec.dimension := substr(pTimeParameter, 1, instr(pTimeParameter,'+')-1);
5504: ,x_return_status => x_return_status
5505: ,x_msg_count => x_msg_count
5506: ,x_msg_data => x_msg_data);
5507:
5508: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5509: RETURN;
5510: END IF;
5511:
5512: l_parameter_rec.default_flag := 'N';
5520: ,x_return_status => x_return_status
5521: ,x_msg_count => x_msg_count
5522: ,x_msg_data => x_msg_data);
5523:
5524: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5525: RETURN;
5526: END IF;
5527:
5528: --BIS_P_ASOF_DATE Record
5602: );
5603:
5604: /*-----BugFix#2887200 -ansingh-------*/
5605:
5606: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5607: RETURN;
5608: END IF;
5609:
5610: ELSE
5670: ,x_return_status => x_return_status
5671: ,x_msg_count => x_msg_count
5672: ,x_msg_data => x_msg_Data
5673: );
5674: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5675: RETURN;
5676: END IF;
5677: END IF;
5678: END IF;
5677: END IF;
5678: END IF;
5679: COMMIT;
5680: EXCEPTION
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: ROLLBACK;
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5679: COMMIT;
5680: EXCEPTION
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: ROLLBACK;
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: ROLLBACK;
5687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: ROLLBACK;
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: ROLLBACK;
5687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5689: WHEN OTHERS THEN
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5686: ROLLBACK;
5687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5689: WHEN OTHERS THEN
5690: ROLLBACK;
5691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5689: WHEN OTHERS THEN
5690: ROLLBACK;
5691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5692: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5693: END;
5694:
5695: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS
5989:
5990: END IF; -- if param name is not null
5991:
5992: EXCEPTION
5993: WHEN FND_API.G_EXC_ERROR THEN
5994: ROLLBACK;
5995: x_return_status := FND_API.G_RET_STS_ERROR;
5996: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5991:
5992: EXCEPTION
5993: WHEN FND_API.G_EXC_ERROR THEN
5994: ROLLBACK;
5995: x_return_status := FND_API.G_RET_STS_ERROR;
5996: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5998: ROLLBACK;
5999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5993: WHEN FND_API.G_EXC_ERROR THEN
5994: ROLLBACK;
5995: x_return_status := FND_API.G_RET_STS_ERROR;
5996: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5998: ROLLBACK;
5999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6000: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6001: WHEN OTHERS THEN
5995: x_return_status := FND_API.G_RET_STS_ERROR;
5996: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
5997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5998: ROLLBACK;
5999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6000: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6001: WHEN OTHERS THEN
6002: ROLLBACK;
6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6000: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6001: WHEN OTHERS THEN
6002: ROLLBACK;
6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6005:
6006: END VALIDATE_DRILL_PARAMETER;
6007:
6392:
6393: COMMIT;
6394:
6395: EXCEPTION
6396: WHEN FND_API.G_EXC_ERROR THEN
6397: x_return_status := FND_API.G_RET_STS_ERROR;
6398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6393: COMMIT;
6394:
6395: EXCEPTION
6396: WHEN FND_API.G_EXC_ERROR THEN
6397: x_return_status := FND_API.G_RET_STS_ERROR;
6398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6395: EXCEPTION
6396: WHEN FND_API.G_EXC_ERROR THEN
6397: x_return_status := FND_API.G_RET_STS_ERROR;
6398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6402: WHEN OTHERS THEN
6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6396: WHEN FND_API.G_EXC_ERROR THEN
6397: x_return_status := FND_API.G_RET_STS_ERROR;
6398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6402: WHEN OTHERS THEN
6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6404: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6402: WHEN OTHERS THEN
6403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6404: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6405: END copyParamtersBetweenPages;
6406:
6407: procedure executeLovBindSQL
6528:
6529: dbms_sql.close_cursor(l_cursor);
6530:
6531: EXCEPTION
6532: WHEN FND_API.G_EXC_ERROR THEN
6533: x_return_status := FND_API.G_RET_STS_ERROR;
6534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6529: dbms_sql.close_cursor(l_cursor);
6530:
6531: EXCEPTION
6532: WHEN FND_API.G_EXC_ERROR THEN
6533: x_return_status := FND_API.G_RET_STS_ERROR;
6534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6537: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6531: EXCEPTION
6532: WHEN FND_API.G_EXC_ERROR THEN
6533: x_return_status := FND_API.G_RET_STS_ERROR;
6534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6537: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6538: WHEN OTHERS THEN
6539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6532: WHEN FND_API.G_EXC_ERROR THEN
6533: x_return_status := FND_API.G_RET_STS_ERROR;
6534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6537: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6538: WHEN OTHERS THEN
6539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6540: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6537: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6538: WHEN OTHERS THEN
6539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6540: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6541: END executeLovDynamicSQL;
6542:
6543: PROCEDURE copyParamsFromReportToPage(
6671: END IF; --lRegionCode
6672:
6673: COMMIT;
6674: EXCEPTION
6675: WHEN FND_API.G_EXC_ERROR THEN
6676: x_return_status := FND_API.G_RET_STS_ERROR;
6677: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6672:
6673: COMMIT;
6674: EXCEPTION
6675: WHEN FND_API.G_EXC_ERROR THEN
6676: x_return_status := FND_API.G_RET_STS_ERROR;
6677: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6674: EXCEPTION
6675: WHEN FND_API.G_EXC_ERROR THEN
6676: x_return_status := FND_API.G_RET_STS_ERROR;
6677: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6681: WHEN OTHERS THEN
6682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6675: WHEN FND_API.G_EXC_ERROR THEN
6676: x_return_status := FND_API.G_RET_STS_ERROR;
6677: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6681: WHEN OTHERS THEN
6682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6681: WHEN OTHERS THEN
6682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
6684:
6685: END copyParamsFromReportToPage;
6686:
6929: );
6930: x_time_level_id := l_time_level_id;
6931: x_time_level_value := l_time_level_value;
6932:
6933: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6934: RETURN;
6935: END IF;
6936:
6937: saveDateParams(
7077: x_msg_count => l_msg_count,
7078: x_msg_Data => l_msg_Data
7079: );
7080:
7081: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7082: RETURN;
7083: END IF;
7084:
7085: --l_prev_asof_date_desc := to_char(l_prev_asof_date,'DD-MON-YYYY');