11: p_init_msg_list IN VARCHAR2
12: ) IS
13: BEGIN
14: IF (FND_API.to_boolean(p_init_msg_list)) THEN
15: FND_MSG_PUB.initialize;
16: END IF;
17: EXCEPTION
18: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
19: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
71: l_return_value VARCHAR2(200) := OKL_API.G_RET_STS_UNEXP_ERROR;
72: BEGIN
73: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_api_name || p_api_type);
74: IF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_ERROR' THEN
75: FND_MSG_PUB.Count_And_Get
76: (
77: p_count => x_msg_count,
78: p_data => x_msg_data
79: );
78: p_data => x_msg_data
79: );
80: l_return_value := OKL_API.G_RET_STS_ERROR;
81: ELSIF UPPER(p_exc_name) = 'OKL_API.G_RET_STS_UNEXP_ERROR' THEN
82: FND_MSG_PUB.Count_And_Get
83: (
84: p_count => x_msg_count,
85: p_data => x_msg_data
86: );
84: p_count => x_msg_count,
85: p_data => x_msg_data
86: );
87: ELSE -- WHEN OTHERS EXCEPTION
88: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg
91: (
92: p_pkg_name,
86: );
87: ELSE -- WHEN OTHERS EXCEPTION
88: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg
91: (
92: p_pkg_name,
93: p_api_name
94: );
92: p_pkg_name,
93: p_api_name
94: );
95: END IF;
96: FND_MSG_PUB.Count_And_Get
97: (
98: p_count => x_msg_count,
99: p_data => x_msg_data
100: );
109: x_msg_data OUT NOCOPY VARCHAR2
110: ) IS
111: BEGIN
112: --- Standard call to get message count and if count is 1, get message info
113: FND_MSG_PUB.Count_And_Get (
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116: END end_activity;
117: --------------------------------------------------------------------------------
182: IF (p_token10 IS NOT NULL) AND (p_token10_value IS NOT NULL) THEN
183: FND_MESSAGE.SET_TOKEN( TOKEN => p_token10,
184: VALUE => p_token10_value);
185: END IF;
186: FND_MSG_PUB.add;
187: END set_message;
188:
189: -- rmunjulu Added function which gets customer baseline
190: -- Returns H if customer coming from H to R12