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

APPS.BIS_PMV_PARAMETERS_PVT dependencies on FND_MSG_PUB

Line 1831: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count

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
1835: WHEN FND_API.G_EXC_ERROR THEN

Line 1837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, 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);
1841: WHEN OTHERS THEN

Line 1840: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
1844: END COPY_SES_TO_DEF_PARAMETERS;

Line 1843: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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 */
1847: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation

Line 1885: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 1888: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
1892:

Line 1891: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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:
1895: PROCEDURE VALIDATE_AND_SAVE

Line 1950: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_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);
1954: WHEN OTHERS THEN

Line 1953: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
1957: END VALIDATE_AND_SAVE;

Line 1956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
1960: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_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);
2038: WHEN OTHERS THEN

Line 2037: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2041: END VALIDATE_AND_SAVE_TIME;

Line 2040: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2044: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 2093: FND_MSG_PUB.ADD;

2089: x_valid := 'N';
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

Line 2151: FND_MSG_PUB.ADD;

2147: x_valid := 'N';
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

Line 2166: FND_MSG_PUB.ADD;

2162: ELSIF p_parameter_rec.parameter_name = 'VIEW_BY' THEN
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;

Line 2203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2206: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2210: END VALIDATE_NONTIME_PARAMETER;

Line 2209: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2213: FUNCTION GET_DELEGATION_VALIDATED_VALUE(

Line 2351: FND_MSG_PUB.ADD;

2347: x_valid := 'N';
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

Line 2392: FND_MSG_PUB.ADD;

2388: x_valid := 'N';
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:

Line 2434: FND_MSG_PUB.ADD;

2430: x_valid := 'N';
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

Line 2441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2448: END VALIDATE_TIME_PARAMETER;

Line 2447: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2451: (p_code IN VARCHAR2

Line 2552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2555: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2559: END CREATE_PARAMETER;

Line 2558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2562: (p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type

Line 2607: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2614: END RETRIEVE_PARAMETER;

Line 2613: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2617: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

Line 2731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2734: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2738: END RETRIEVE_PAGE_PARAMETER;

Line 2737: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2741: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

Line 2819: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2826: END RETRIEVE_KPI_PARAMETER;

Line 2825: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2829: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

Line 2852: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 2855: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
2859: END RETRIEVE_SCHEDULE_PARAMETER;

Line 2858: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2862: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 2896: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
2900: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 2900: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
2904: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 2904: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2908: (p_parameter_name IN VARCHAR2

Line 2923: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
2927: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 2927: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
2931: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 2931: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
2935: (p_user_param_tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

Line 3008: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
3012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 3012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
3016: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 3016: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3020: (p_schedule_id IN NUMBER

Line 3122: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3125: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3129: END RETRIEVE_PAGE_PARAMETERS;

Line 3128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3132: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 3204: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3207: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3211: END RETRIEVE_KPI_PARAMETERS;

Line 3210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3214: (p_user_session_Rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 3322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3325: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3329:

Line 3328: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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:
3332: PROCEDURE RETRIEVE_SCHEDULE_PARAMETERS

Line 3389: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3392: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3396: END RETRIEVE_SCHEDULE_PARAMETERS;

Line 3395: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3399: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 3461: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3468: END RETRIEVE_SESSION_PARAMETERS;

Line 3467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3471: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 3533: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3536: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3540: END RETRIEVE_DEFAULT_PARAMETERS;

Line 3539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3543: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 3572: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3575: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3579: END DELETE_SESSION_PARAMETERS;

Line 3578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3582: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 3596: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3599: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3603:

Line 3602: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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:
3606: PROCEDURE DELETE_DEFAULT_PARAMETERS

Line 3622: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3625: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3629:

Line 3628: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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:
3632: PROCEDURE DELETE_SCHEDULE_PARAMETERS

Line 3646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
3650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 3650: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
3654: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 3654: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3658: (p_parameter_name in varchar2

Line 3726: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3729: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3733: END GET_NONTIME_VALIDATED_VALUE;

Line 3732: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3736: (p_parameter_name in varchar2

Line 3802: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3805: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3809: END GET_NONTIME_VALIDATED_ID;

Line 3808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3812: (p_parameter_name IN VARCHAR2

Line 3878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3881: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3885: END GET_TIME_VALIDATED_VALUE;

Line 3884: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3888: (p_parameter_name IN VARCHAR2

Line 3956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 3959: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
3963: END GET_TIME_VALIDATED_ID;

Line 3962: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
3966: (p_region_code in varchar2

Line 4026: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 4029: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
4033: END GET_TIME_INFO;

Line 4032: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
4036: (p_parameter_name in varchar2

Line 4209: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));

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

Line 4345: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 4348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
4352: END getLOVSQL;

Line 4351: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
4355: (p_parameter_name in varchar2

Line 4509: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));

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

Line 4619: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));

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:

Line 4745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 4748: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
4752: END getTimeLovSql;

Line 4751: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
4755: (pRegionCode in varchar2,

Line 4916: FND_MSG_PUB.INITIALIZE;

4912: l_prev_time_level_value VARCHAR2(2000);
4913:
4914: BEGIN
4915: --First delete all the parameters for this session.
4916: FND_MSG_PUB.INITIALIZE;
4917: l_user_session_rec.function_name := pFunctionNAme;
4918: l_user_session_rec.region_code := pRegionCode;
4919: l_user_session_rec.page_id := pPageId;
4920: l_user_session_rec.session_id := pSessionId;

Line 5684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
5688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 5688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
5692: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 5692: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
5696: PROCEDURE RETRIEVE_GRAPH_FILEID(p_user_id in varchar2,

Line 5996: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
6000: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 6000: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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;
6004: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 6004: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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:
6008: FUNCTION GET_PARAM_LOV_WHERE (

Line 6398: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 6401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
6405: END copyParamtersBetweenPages;

Line 6404: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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
6408: (p_bind_sql in varchar2

Line 6534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 6537: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
6541: END executeLovDynamicSQL;

Line 6540: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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(
6544: pFunctionName IN VARCHAR2,

Line 6677: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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

Line 6680: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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);
6684:

Line 6683: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

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:
6687: PROCEDURE saveDateParams(