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.CN_COLUMN_MAPS_PVT dependencies on FND_API

Line 17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

13: -----------------------------------------------------------------------------+
14: PROCEDURE insert_row
15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

Line 18: p_commit IN VARCHAR2 := FND_API.G_FALSE,

14: PROCEDURE insert_row
15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,

Line 19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: p_destination_column_id IN NUMBER,

Line 42: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT insert_row_sv;
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
43: p_api_version ,
44: l_api_name,
45: G_PKG_NAME ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
43: p_api_version ,
44: l_api_name,
45: G_PKG_NAME ) THEN
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;

Line 49: IF FND_API.to_Boolean( p_init_msg_list ) THEN

45: G_PKG_NAME ) THEN
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;

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
55:
56:
57: cn_column_maps_pkg.Insert_Row

Line 75: IF FND_API.To_Boolean( p_commit ) THEN

71: x_col_map_id := l_column_map_id;
72:
73: -- End of API body.
74: -- Standard check of p_commit.
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

Line 82: p_encoded => FND_API.G_FALSE );

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:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: ROLLBACK TO insert_row_sv;

Line 85: WHEN FND_API.G_EXC_ERROR THEN

81: p_data => x_msg_data ,
82: p_encoded => FND_API.G_FALSE );
83:
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 ,

Line 87: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 91: p_encoded => FND_API.G_FALSE);

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
93: ROLLBACK TO insert_row_sv;
94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
95: FND_MSG_PUB.Count_And_Get(

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

90: p_data => x_msg_data ,
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);

Line 98: p_encoded => FND_API.G_FALSE);

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
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(

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

97: p_data => x_msg_data ,
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;

Line 109: p_encoded => FND_API.G_FALSE);

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;
111:
112: -----------------------------------------------------------------------------+
113: -- Procedure : update_row

Line 118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

114: -----------------------------------------------------------------------------+
115: PROCEDURE update_row
116: (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,

Line 119: p_commit IN VARCHAR2 := FND_API.G_FALSE,

115: PROCEDURE update_row
116: (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,

Line 120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

116: (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_commit IN VARCHAR2 := FND_API.G_FALSE,
120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_column_map_id IN NUMBER,

Line 149: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

145: BEGIN
146: -- Standard Start of API savepoint
147: SAVEPOINT update_row_sv;
148: -- Standard call to check for call compatibility.
149: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
150: p_api_version ,
151: l_api_name,
152: G_PKG_NAME ) THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
150: p_api_version ,
151: l_api_name,
152: G_PKG_NAME ) THEN
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;

Line 156: IF FND_API.to_Boolean( p_init_msg_list ) THEN

152: G_PKG_NAME ) THEN
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;

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
162:
163: -- check if the object version number is the same
164: OPEN l_ovn_csr;

Line 176: RAISE FND_API.G_EXC_ERROR;

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:
178: end if;
179:
180:

Line 201: IF FND_API.To_Boolean( p_commit ) THEN

197: p_object_version_number := l_object_version_number + 1;
198:
199: -- End of API body.
200: -- Standard check of p_commit.
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

Line 208: p_encoded => FND_API.G_FALSE );

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
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO update_row_sv;
212: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 210: WHEN FND_API.G_EXC_ERROR THEN

206: (p_count => x_msg_count ,
207: p_data => x_msg_data ,
208: p_encoded => FND_API.G_FALSE );
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 ,

Line 212: x_return_status := FND_API.G_RET_STS_ERROR ;

208: p_encoded => FND_API.G_FALSE );
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);

Line 216: p_encoded => FND_API.G_FALSE);

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
218: ROLLBACK TO update_row_sv;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: FND_MSG_PUB.Count_And_Get(

Line 217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

215: p_data => x_msg_data ,
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);

Line 223: p_encoded => FND_API.G_FALSE);

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
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(

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

222: p_data => x_msg_data ,
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;

Line 234: p_encoded => FND_API.G_FALSE);

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;
236:
237: -----------------------------------------------------------------------------+
238: -- Procedure : delete_row

Line 243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

239: -----------------------------------------------------------------------------+
240: PROCEDURE delete_row
241: (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,

Line 244: p_commit IN VARCHAR2 := FND_API.G_FALSE,

240: PROCEDURE delete_row
241: (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,

Line 245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

241: (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
244: p_commit IN VARCHAR2 := FND_API.G_FALSE,
245: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: p_column_map_id IN NUMBER,

Line 259: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

255: BEGIN
256: -- Standard Start of API savepoint
257: SAVEPOINT delete_row_sv;
258: -- Standard call to check for call compatibility.
259: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
260: p_api_version ,
261: l_api_name,
262: G_PKG_NAME ) THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
260: p_api_version ,
261: l_api_name,
262: G_PKG_NAME ) THEN
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;

Line 266: IF FND_API.to_Boolean( p_init_msg_list ) THEN

262: G_PKG_NAME ) THEN
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;

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
272:
273: cn_column_maps_pkg.Delete_Row
274: (x_column_map_id => p_column_map_id, x_org_id => p_org_id);

Line 278: IF FND_API.To_Boolean( p_commit ) THEN

274: (x_column_map_id => p_column_map_id, x_org_id => p_org_id);
275:
276: -- End of API body.
277: -- Standard check of p_commit.
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

Line 285: p_encoded => FND_API.G_FALSE );

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
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO delete_row_sv;
289: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: (p_count => x_msg_count ,
284: p_data => x_msg_data ,
285: p_encoded => FND_API.G_FALSE );
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 ,

Line 289: x_return_status := FND_API.G_RET_STS_ERROR ;

285: p_encoded => FND_API.G_FALSE );
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);

Line 293: p_encoded => FND_API.G_FALSE);

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
295: ROLLBACK TO delete_row_sv;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
297: FND_MSG_PUB.Count_And_Get(

Line 294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

292: p_data => x_msg_data ,
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);

Line 300: p_encoded => FND_API.G_FALSE);

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
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(

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

299: p_data => x_msg_data ,
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;

Line 311: p_encoded => FND_API.G_FALSE);

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:
313: END delete_row;
314:
315: