APPS.PA_STATUSES_PVT dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.initialize;

72:
73: -- Initialize the message table if requested.
74:
75: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79:
80: -- Set API return status to success

Line 124: l_msg_count := FND_MSG_PUB.count_msg;

120: x_msg_count => l_msg_count ,
121: x_msg_data => l_msg_data);
122:
123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
124: l_msg_count := FND_MSG_PUB.count_msg;
125: If l_msg_count > 0 THEN
126: x_msg_count := l_msg_count;
127: If l_msg_count = 1 THEN
128: pa_interface_utils_pub.get_messages

Line 159: FND_MSG_PUB.Count_And_Get

155:
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO delete_status_pub;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count ,
161: p_data => x_msg_data );
162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 166: FND_MSG_PUB.Count_And_Get

162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO delete_status_pub;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count ,
168: p_data => x_msg_data );
169:
170: WHEN ROW_ALREADY_LOCKED THEN

Line 174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

170: WHEN ROW_ALREADY_LOCKED THEN
171: ROLLBACK TO delete_status_pub;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173:
174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
175: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
176: FND_MESSAGE.SET_TOKEN('ENTITY', p_pa_project_status_code);
177: FND_MSG_PUB.ADD;
178: END IF;

Line 177: FND_MSG_PUB.ADD;

173:
174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
175: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
176: FND_MESSAGE.SET_TOKEN('ENTITY', p_pa_project_status_code);
177: FND_MSG_PUB.ADD;
178: END IF;
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count ,
181: p_data => x_msg_data );

Line 179: FND_MSG_PUB.Count_And_Get

175: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
176: FND_MESSAGE.SET_TOKEN('ENTITY', p_pa_project_status_code);
177: FND_MSG_PUB.ADD;
178: END IF;
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count ,
181: p_data => x_msg_data );
182:
183: WHEN OTHERS THEN

Line 186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

182:
183: WHEN OTHERS THEN
184: ROLLBACK TO delete_status_pub;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
187: FND_MSG_PUB.add_exc_msg
188: ( p_pkg_name => G_PKG_NAME
189: , p_procedure_name => l_api_name
190: , p_error_text => SUBSTR(SQLERRM, 1, 240) );

Line 187: FND_MSG_PUB.add_exc_msg

183: WHEN OTHERS THEN
184: ROLLBACK TO delete_status_pub;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
187: FND_MSG_PUB.add_exc_msg
188: ( p_pkg_name => G_PKG_NAME
189: , p_procedure_name => l_api_name
190: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
191: FND_MSG_PUB.add;

Line 191: FND_MSG_PUB.add;

187: FND_MSG_PUB.add_exc_msg
188: ( p_pkg_name => G_PKG_NAME
189: , p_procedure_name => l_api_name
190: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
191: FND_MSG_PUB.add;
192: END IF;
193:
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count ,

Line 194: FND_MSG_PUB.Count_And_Get

190: , p_error_text => SUBSTR(SQLERRM, 1, 240) );
191: FND_MSG_PUB.add;
192: END IF;
193:
194: FND_MSG_PUB.Count_And_Get
195: ( p_count => x_msg_count ,
196: p_data => x_msg_data );
197:
198: END delete_status_pvt;