DBA Data[Home] [Help]

APPS.CN_COLUMN_MAPS_PVT dependencies on FND_MSG_PUB

Line 50: FND_MSG_PUB.initialize;

46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: -- Initialize message list if p_init_msg_list is set to TRUE.
49: IF FND_API.to_Boolean( p_init_msg_list ) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52: -- Initialize API return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54: -- API Body Begin

Line 79: FND_MSG_PUB.Count_And_Get

75: IF FND_API.To_Boolean( p_commit ) THEN
76: COMMIT WORK;
77: END IF;
78: -- Standard call to get message count and if count is 1, get message info.
79: FND_MSG_PUB.Count_And_Get
80: (p_count => x_msg_count ,
81: p_data => x_msg_data ,
82: p_encoded => FND_API.G_FALSE );
83:

Line 88: FND_MSG_PUB.Count_And_Get(

84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: ROLLBACK TO insert_row_sv;
87: x_return_status := FND_API.G_RET_STS_ERROR ;
88: FND_MSG_PUB.Count_And_Get(
89: p_count => x_msg_count ,
90: p_data => x_msg_data ,
91: p_encoded => FND_API.G_FALSE);
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 95: FND_MSG_PUB.Count_And_Get(

91: p_encoded => FND_API.G_FALSE);
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ROLLBACK TO insert_row_sv;
94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
95: FND_MSG_PUB.Count_And_Get(
96: p_count => x_msg_count ,
97: p_data => x_msg_data ,
98: p_encoded => FND_API.G_FALSE);
99: WHEN OTHERS THEN

Line 102: IF FND_MSG_PUB.Check_Msg_Level(

98: p_encoded => FND_API.G_FALSE);
99: WHEN OTHERS THEN
100: ROLLBACK TO insert_row_sv;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(

Line 103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

99: WHEN OTHERS THEN
100: ROLLBACK TO insert_row_sv;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count ,

Line 104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

100: ROLLBACK TO insert_row_sv;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count ,
108: p_data => x_msg_data ,

Line 106: FND_MSG_PUB.Count_And_Get(

102: IF FND_MSG_PUB.Check_Msg_Level(
103: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
105: END IF;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count ,
108: p_data => x_msg_data ,
109: p_encoded => FND_API.G_FALSE);
110: END insert_row;

Line 157: FND_MSG_PUB.initialize;

153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: -- API Body Begin

Line 170: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

166: CLOSE l_ovn_csr;
167:
168: if (l_object_version_number <> p_object_version_number) THEN
169:
170: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
171: THEN
172: fnd_message.set_name('CN', 'CL_INVALID_OVN');
173: fnd_msg_pub.add;
174: END IF;

Line 173: fnd_msg_pub.add;

169:
170: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
171: THEN
172: fnd_message.set_name('CN', 'CL_INVALID_OVN');
173: fnd_msg_pub.add;
174: END IF;
175:
176: RAISE FND_API.G_EXC_ERROR;
177:

Line 205: FND_MSG_PUB.Count_And_Get

201: IF FND_API.To_Boolean( p_commit ) THEN
202: COMMIT WORK;
203: END IF;
204: -- Standard call to get message count and if count is 1, get message info.
205: FND_MSG_PUB.Count_And_Get
206: (p_count => x_msg_count ,
207: p_data => x_msg_data ,
208: p_encoded => FND_API.G_FALSE );
209: EXCEPTION

Line 213: FND_MSG_PUB.Count_And_Get(

209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO update_row_sv;
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get(
214: p_count => x_msg_count ,
215: p_data => x_msg_data ,
216: p_encoded => FND_API.G_FALSE);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 220: FND_MSG_PUB.Count_And_Get(

216: p_encoded => FND_API.G_FALSE);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: ROLLBACK TO update_row_sv;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: FND_MSG_PUB.Count_And_Get(
221: p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE);
224: WHEN OTHERS THEN

Line 227: IF FND_MSG_PUB.Check_Msg_Level(

223: p_encoded => FND_API.G_FALSE);
224: WHEN OTHERS THEN
225: ROLLBACK TO update_row_sv;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(

Line 228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

224: WHEN OTHERS THEN
225: ROLLBACK TO update_row_sv;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,

Line 229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

225: ROLLBACK TO update_row_sv;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,

Line 231: FND_MSG_PUB.Count_And_Get(

227: IF FND_MSG_PUB.Check_Msg_Level(
228: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
230: END IF;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count ,
233: p_data => x_msg_data ,
234: p_encoded => FND_API.G_FALSE);
235: END update_row;

Line 267: FND_MSG_PUB.initialize;

263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: -- Initialize message list if p_init_msg_list is set to TRUE.
266: IF FND_API.to_Boolean( p_init_msg_list ) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269: -- Initialize API return status to success
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: -- API Body Begin

Line 282: FND_MSG_PUB.Count_And_Get

278: IF FND_API.To_Boolean( p_commit ) THEN
279: COMMIT WORK;
280: END IF;
281: -- Standard call to get message count and if count is 1, get message info.
282: FND_MSG_PUB.Count_And_Get
283: (p_count => x_msg_count ,
284: p_data => x_msg_data ,
285: p_encoded => FND_API.G_FALSE );
286: EXCEPTION

Line 290: FND_MSG_PUB.Count_And_Get(

286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO delete_row_sv;
289: x_return_status := FND_API.G_RET_STS_ERROR ;
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count ,
292: p_data => x_msg_data ,
293: p_encoded => FND_API.G_FALSE);
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 297: FND_MSG_PUB.Count_And_Get(

293: p_encoded => FND_API.G_FALSE);
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO delete_row_sv;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
297: FND_MSG_PUB.Count_And_Get(
298: p_count => x_msg_count ,
299: p_data => x_msg_data ,
300: p_encoded => FND_API.G_FALSE);
301: WHEN OTHERS THEN

Line 304: IF FND_MSG_PUB.Check_Msg_Level(

300: p_encoded => FND_API.G_FALSE);
301: WHEN OTHERS THEN
302: ROLLBACK TO delete_row_sv;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(

Line 305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

301: WHEN OTHERS THEN
302: ROLLBACK TO delete_row_sv;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
309: p_count => x_msg_count ,

Line 306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

302: ROLLBACK TO delete_row_sv;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
309: p_count => x_msg_count ,
310: p_data => x_msg_data ,

Line 308: FND_MSG_PUB.Count_And_Get(

304: IF FND_MSG_PUB.Check_Msg_Level(
305: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
307: END IF;
308: FND_MSG_PUB.Count_And_Get(
309: p_count => x_msg_count ,
310: p_data => x_msg_data ,
311: p_encoded => FND_API.G_FALSE);
312: