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.

[Home] [Help]

APPS.CN_USER_ACCESS_PVT dependencies on FND_API

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

15: -- End of comments
16:
17: PROCEDURE Create_User_Access
18: (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_rec IN user_access_rec_type,
23: x_return_status OUT NOCOPY VARCHAR2,

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

16:
17: PROCEDURE Create_User_Access
18: (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_rec IN user_access_rec_type,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,

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

17: PROCEDURE Create_User_Access
18: (p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20: p_commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: p_rec IN user_access_rec_type,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,

Line 38: IF NOT FND_API.Compatible_API_Call

34: -- Standard Start of API savepoint
35: SAVEPOINT Create_User_Access;
36:
37: -- Standard call to check for call compatibility.
38: IF NOT FND_API.Compatible_API_Call
39: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42:

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

36:
37: -- Standard call to check for call compatibility.
38: IF NOT FND_API.Compatible_API_Call
39: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 44: IF FND_API.to_Boolean( p_init_msg_list ) THEN

40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.to_Boolean( p_init_msg_list ) THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Initialize API return status to success

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Initialize API return status to success
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50:
51: -- make sure the access level for the current comp group and org
52: -- isn't already assigned
53: select count(user_access_id) into l_count

Line 61: RAISE FND_API.G_EXC_ERROR;

57: and org_code = l_newrec.org_code;
58: IF l_count > 0 THEN
59: FND_MESSAGE.SET_NAME ('CN' , 'CN_ACCESS_DUP_ERR');
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63:
64: cn_user_access_pkg.insert_row(l_newrec);
65:

Line 67: IF FND_API.To_Boolean( p_commit ) THEN

63:
64: cn_user_access_pkg.insert_row(l_newrec);
65:
66: -- Standard check of p_commit.
67: IF FND_API.To_Boolean( p_commit ) THEN
68: COMMIT WORK;
69: END IF;
70:
71: FND_MSG_PUB.Count_And_Get

Line 74: p_encoded => FND_API.G_FALSE);

70:
71: FND_MSG_PUB.Count_And_Get
72: (p_count => x_msg_count,
73: p_data => x_msg_data,
74: p_encoded => FND_API.G_FALSE);
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: ROLLBACK TO Create_User_Access;

Line 77: WHEN FND_API.G_EXC_ERROR THEN

73: p_data => x_msg_data,
74: p_encoded => FND_API.G_FALSE);
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: ROLLBACK TO Create_User_Access;
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MSG_PUB.Count_And_Get
81: (p_count => x_msg_count,

Line 79: x_return_status := FND_API.G_RET_STS_ERROR;

75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: ROLLBACK TO Create_User_Access;
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MSG_PUB.Count_And_Get
81: (p_count => x_msg_count,
82: p_data => x_msg_data,
83: p_encoded => FND_API.G_FALSE);

Line 83: p_encoded => FND_API.G_FALSE);

79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MSG_PUB.Count_And_Get
81: (p_count => x_msg_count,
82: p_data => x_msg_data,
83: p_encoded => FND_API.G_FALSE);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
85: ROLLBACK TO Create_User_Access;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: FND_MSG_PUB.Count_And_Get

Line 84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

80: FND_MSG_PUB.Count_And_Get
81: (p_count => x_msg_count,
82: p_data => x_msg_data,
83: p_encoded => FND_API.G_FALSE);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
85: ROLLBACK TO Create_User_Access;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: FND_MSG_PUB.Count_And_Get
88: (p_count => x_msg_count,

Line 86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

82: p_data => x_msg_data,
83: p_encoded => FND_API.G_FALSE);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
85: ROLLBACK TO Create_User_Access;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: FND_MSG_PUB.Count_And_Get
88: (p_count => x_msg_count,
89: p_data => x_msg_data,
90: p_encoded => FND_API.G_FALSE);

Line 90: p_encoded => FND_API.G_FALSE);

86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: FND_MSG_PUB.Count_And_Get
88: (p_count => x_msg_count,
89: p_data => x_msg_data,
90: p_encoded => FND_API.G_FALSE);
91: WHEN OTHERS THEN
92: ROLLBACK TO Create_User_Access;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89: p_data => x_msg_data,
90: p_encoded => FND_API.G_FALSE);
91: WHEN OTHERS THEN
92: ROLLBACK TO Create_User_Access;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
95: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
96: END IF;
97: FND_MSG_PUB.Count_And_Get

Line 100: p_encoded => FND_API.G_FALSE);

96: END IF;
97: FND_MSG_PUB.Count_And_Get
98: (p_count => x_msg_count,
99: p_data => x_msg_data,
100: p_encoded => FND_API.G_FALSE);
101: END Create_User_Access;
102:
103: -- Start of comments
104: -- API name : Update_User_Access

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

111: -- End of comments
112:
113: PROCEDURE Update_User_Access
114: (p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: p_rec IN user_access_rec_type,
119: x_return_status OUT NOCOPY VARCHAR2,

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

112:
113: PROCEDURE Update_User_Access
114: (p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: p_rec IN user_access_rec_type,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,

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

113: PROCEDURE Update_User_Access
114: (p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118: p_rec IN user_access_rec_type,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 132: IF NOT FND_API.Compatible_API_Call

128: -- Standard Start of API savepoint
129: SAVEPOINT Update_User_Access;
130:
131: -- Standard call to check for call compatibility.
132: IF NOT FND_API.Compatible_API_Call
133: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130:
131: -- Standard call to check for call compatibility.
132: IF NOT FND_API.Compatible_API_Call
133: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: -- Initialize message list if p_init_msg_list is set to TRUE.
138: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 138: IF FND_API.to_Boolean( p_init_msg_list ) THEN

134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: -- Initialize message list if p_init_msg_list is set to TRUE.
138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: -- Initialize API return status to success

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: -- Initialize API return status to success
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: -- make sure record to be updated exists.
146: select count(*) into l_count
147: from cn_user_accesses

Line 153: RAISE FND_API.G_EXC_ERROR;

149:
150: if l_count = 0 then
151: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');
152: FND_MSG_PUB.ADD;
153: RAISE FND_API.G_EXC_ERROR;
154: end if;
155:
156: -- make sure the access level for the current comp group and org
157: -- isn't already assigned

Line 167: RAISE FND_API.G_EXC_ERROR;

163: and user_access_id <> l_newrec.user_access_id;
164: IF l_count > 0 THEN
165: FND_MESSAGE.SET_NAME ('CN' , 'CN_ACCESS_DUP_ERR');
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169:
170: -- make sure the object version number hasn't changed in the meantime
171: cn_user_access_pkg.lock_row(l_newrec.user_access_id,

Line 177: IF FND_API.To_Boolean( p_commit ) THEN

173:
174: cn_user_access_pkg.update_row(l_newrec);
175:
176: -- Standard check of p_commit.
177: IF FND_API.To_Boolean( p_commit ) THEN
178: COMMIT WORK;
179: END IF;
180:
181: FND_MSG_PUB.Count_And_Get

Line 184: p_encoded => FND_API.G_FALSE);

180:
181: FND_MSG_PUB.Count_And_Get
182: (p_count => x_msg_count,
183: p_data => x_msg_data,
184: p_encoded => FND_API.G_FALSE);
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO Update_User_Access;
188: x_return_status := FND_API.G_RET_STS_ERROR;

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: (p_count => x_msg_count,
183: p_data => x_msg_data,
184: p_encoded => FND_API.G_FALSE);
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO Update_User_Access;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get
190: (p_count => x_msg_count,

Line 188: x_return_status := FND_API.G_RET_STS_ERROR;

184: p_encoded => FND_API.G_FALSE);
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: ROLLBACK TO Update_User_Access;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get
190: (p_count => x_msg_count,
191: p_data => x_msg_data,
192: p_encoded => FND_API.G_FALSE);

Line 192: p_encoded => FND_API.G_FALSE);

188: x_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get
190: (p_count => x_msg_count,
191: p_data => x_msg_data,
192: p_encoded => FND_API.G_FALSE);
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO Update_User_Access;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get

Line 193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

189: FND_MSG_PUB.Count_And_Get
190: (p_count => x_msg_count,
191: p_data => x_msg_data,
192: p_encoded => FND_API.G_FALSE);
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO Update_User_Access;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get
197: (p_count => x_msg_count,

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: p_data => x_msg_data,
192: p_encoded => FND_API.G_FALSE);
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO Update_User_Access;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get
197: (p_count => x_msg_count,
198: p_data => x_msg_data,
199: p_encoded => FND_API.G_FALSE);

Line 199: p_encoded => FND_API.G_FALSE);

195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get
197: (p_count => x_msg_count,
198: p_data => x_msg_data,
199: p_encoded => FND_API.G_FALSE);
200: WHEN OTHERS THEN
201: ROLLBACK TO Update_User_Access;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: p_data => x_msg_data,
199: p_encoded => FND_API.G_FALSE);
200: WHEN OTHERS THEN
201: ROLLBACK TO Update_User_Access;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
204: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
205: END IF;
206: FND_MSG_PUB.Count_And_Get

Line 209: p_encoded => FND_API.G_FALSE);

205: END IF;
206: FND_MSG_PUB.Count_And_Get
207: (p_count => x_msg_count,
208: p_data => x_msg_data,
209: p_encoded => FND_API.G_FALSE);
210: END Update_User_Access;
211:
212: -- Start of comments
213: -- API name : Delete_User_Access

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

220: -- End of comments
221:
222: PROCEDURE Delete_User_Access
223: (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: p_user_access_id IN NUMBER,
228: p_object_version_number IN NUMBER,

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

221:
222: PROCEDURE Delete_User_Access
223: (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: p_user_access_id IN NUMBER,
228: p_object_version_number IN NUMBER,
229: x_return_status OUT NOCOPY VARCHAR2,

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

222: PROCEDURE Delete_User_Access
223: (p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: p_user_access_id IN NUMBER,
228: p_object_version_number IN NUMBER,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,

Line 242: IF NOT FND_API.Compatible_API_Call

238: -- Standard Start of API savepoint
239: SAVEPOINT Delete_User_Access;
240:
241: -- Standard call to check for call compatibility.
242: IF NOT FND_API.Compatible_API_Call
243: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240:
241: -- Standard call to check for call compatibility.
242: IF NOT FND_API.Compatible_API_Call
243: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: -- Initialize message list if p_init_msg_list is set to TRUE.
248: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 248: IF FND_API.to_Boolean( p_init_msg_list ) THEN

244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247: -- Initialize message list if p_init_msg_list is set to TRUE.
248: IF FND_API.to_Boolean( p_init_msg_list ) THEN
249: FND_MSG_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to success

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: FND_MSG_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to success
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- make sure record to be deleted exists.
256: select count(*) into l_count
257: from cn_user_accesses

Line 263: RAISE FND_API.G_EXC_ERROR;

259:
260: if l_count = 0 then
261: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DEL_REC');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: end if;
265:
266: -- make sure the object version number hasn't changed in the meantime
267: cn_user_access_pkg.lock_row(p_user_access_id,

Line 273: IF FND_API.To_Boolean( p_commit ) THEN

269:
270: cn_user_access_pkg.delete_row(p_user_access_id);
271:
272: -- Standard check of p_commit.
273: IF FND_API.To_Boolean( p_commit ) THEN
274: COMMIT WORK;
275: END IF;
276:
277: FND_MSG_PUB.Count_And_Get

Line 280: p_encoded => FND_API.G_FALSE);

276:
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count,
279: p_data => x_msg_data,
280: p_encoded => FND_API.G_FALSE);
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: ROLLBACK TO Delete_User_Access;
284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 282: WHEN FND_API.G_EXC_ERROR THEN

278: (p_count => x_msg_count,
279: p_data => x_msg_data,
280: p_encoded => FND_API.G_FALSE);
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: ROLLBACK TO Delete_User_Access;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get
286: (p_count => x_msg_count,

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: p_encoded => FND_API.G_FALSE);
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: ROLLBACK TO Delete_User_Access;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get
286: (p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => FND_API.G_FALSE);

Line 288: p_encoded => FND_API.G_FALSE);

284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get
286: (p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => FND_API.G_FALSE);
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO Delete_User_Access;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_And_Get

Line 289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

285: FND_MSG_PUB.Count_And_Get
286: (p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => FND_API.G_FALSE);
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO Delete_User_Access;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: (p_count => x_msg_count,

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: p_data => x_msg_data,
288: p_encoded => FND_API.G_FALSE);
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO Delete_User_Access;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: (p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => FND_API.G_FALSE);

Line 295: p_encoded => FND_API.G_FALSE);

291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: (p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => FND_API.G_FALSE);
296: WHEN OTHERS THEN
297: ROLLBACK TO Delete_Job_Role;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

294: p_data => x_msg_data,
295: p_encoded => FND_API.G_FALSE);
296: WHEN OTHERS THEN
297: ROLLBACK TO Delete_Job_Role;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
301: END IF;
302: FND_MSG_PUB.Count_And_Get

Line 305: p_encoded => FND_API.G_FALSE);

301: END IF;
302: FND_MSG_PUB.Count_And_Get
303: (p_count => x_msg_count,
304: p_data => x_msg_data,
305: p_encoded => FND_API.G_FALSE);
306: END Delete_User_Access;
307:
308: -- Start of comments
309: -- API name : Get_Accesses - Private

Line 369: RAISE FND_API.G_EXC_error;

365: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
366: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_FM');
367: FND_MSG_PUB.Add;
368: END IF;
369: RAISE FND_API.G_EXC_error;
370: END IF;
371: */
372:
373: