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_QUOTA_CATEGORIES_PUB dependencies on FND_API

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

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpqcatb.pls';
6:
7: PROCEDURE Create_Quota_Category(
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_rec IN quota_category_rec_type,
13: x_return_status OUT NOCOPY VARCHAR2,

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

6:
7: PROCEDURE Create_Quota_Category(
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_rec IN quota_category_rec_type,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,

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

7: PROCEDURE Create_Quota_Category(
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_rec IN quota_category_rec_type,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,

Line 32: IF NOT FND_API.Compatible_API_Call

28: BEGIN
29: -- Standard Start of API savepoint
30: SAVEPOINT Create_Quota_Category;
31: -- Standard call to check for call compatibility.
32: IF NOT FND_API.Compatible_API_Call
33: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

30: SAVEPOINT Create_Quota_Category;
31: -- Standard call to check for call compatibility.
32: IF NOT FND_API.Compatible_API_Call
33: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36: -- Initialize message list if p_init_msg_list is set to TRUE.
37: IF FND_API.to_Boolean( p_init_msg_list ) THEN
38: FND_MSG_PUB.initialize;

Line 37: IF FND_API.to_Boolean( p_init_msg_list ) THEN

33: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36: -- Initialize message list if p_init_msg_list is set to TRUE.
37: IF FND_API.to_Boolean( p_init_msg_list ) THEN
38: FND_MSG_PUB.initialize;
39: END IF;
40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: IF FND_API.to_Boolean( p_init_msg_list ) THEN
38: FND_MSG_PUB.initialize;
39: END IF;
40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: l_newrec.name := p_rec.name;
44: l_newrec.description := p_rec.description;
45: l_newrec.type := p_rec.type;

Line 58: RAISE FND_API.G_EXC_ERROR;

54: WHERE UPPER(name) = UPPER(l_newrec.name);
55: IF l_count > 0 THEN
56: FND_MESSAGE.SET_NAME ('CN','CN_QUOTA_CATEGORY_DUP');
57: FND_MSG_PUB.Add;
58: RAISE FND_API.G_EXC_ERROR;
59: END IF;
60:
61: cn_quota_categories_pkg.insert_row(l_newrec);
62: -- Standard check of p_commit.

Line 63: IF FND_API.To_Boolean( p_commit ) THEN

59: END IF;
60:
61: cn_quota_categories_pkg.insert_row(l_newrec);
62: -- Standard check of p_commit.
63: IF FND_API.To_Boolean( p_commit ) THEN
64: COMMIT WORK;
65: END IF;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,

Line 69: p_encoded => FND_API.G_FALSE);

65: END IF;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,
68: p_data => x_msg_data,
69: p_encoded => FND_API.G_FALSE);
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: ROLLBACK TO Create_Quota_Category;
73: x_return_status := FND_API.G_RET_STS_ERROR;

Line 71: WHEN FND_API.G_EXC_ERROR THEN

67: p_count => x_msg_count,
68: p_data => x_msg_data,
69: p_encoded => FND_API.G_FALSE);
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: ROLLBACK TO Create_Quota_Category;
73: x_return_status := FND_API.G_RET_STS_ERROR;
74: FND_MSG_PUB.Count_And_Get(
75: p_count => x_msg_count,

Line 73: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 77: p_encoded => FND_API.G_FALSE);

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

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

74: FND_MSG_PUB.Count_And_Get(
75: p_count => x_msg_count,
76: p_data => x_msg_data,
77: p_encoded => FND_API.G_FALSE);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO Create_Quota_Category;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: FND_MSG_PUB.Count_And_Get(
82: p_count => x_msg_count,

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: p_data => x_msg_data,
77: p_encoded => FND_API.G_FALSE);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO Create_Quota_Category;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: FND_MSG_PUB.Count_And_Get(
82: p_count => x_msg_count,
83: p_data => x_msg_data,
84: p_encoded => FND_API.G_FALSE);

Line 84: p_encoded => FND_API.G_FALSE);

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

Line 87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

83: p_data => x_msg_data,
84: p_encoded => FND_API.G_FALSE);
85: WHEN OTHERS THEN
86: ROLLBACK TO Create_Quota_Category;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
89: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
90: END IF;
91: FND_MSG_PUB.Count_And_Get(

Line 94: p_encoded => FND_API.G_FALSE);

90: END IF;
91: FND_MSG_PUB.Count_And_Get(
92: p_count => x_msg_count,
93: p_data => x_msg_data,
94: p_encoded => FND_API.G_FALSE);
95: END Create_Quota_Category;
96: --
97:
98: PROCEDURE Update_Quota_Category(

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

96: --
97:
98: PROCEDURE Update_Quota_Category(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_rec IN quota_category_rec_type,
104: x_return_status OUT NOCOPY VARCHAR2,

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

97:
98: PROCEDURE Update_Quota_Category(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_rec IN quota_category_rec_type,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,

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

98: PROCEDURE Update_Quota_Category(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: p_rec IN quota_category_rec_type,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 123: IF NOT FND_API.Compatible_API_Call

119: -- Standard Start of API savepoint
120: SAVEPOINT Update_Quota_Category;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call
124: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call
124: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 129: IF FND_API.to_Boolean( p_init_msg_list ) THEN

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean( p_init_msg_list ) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: -- Initialize API return status to success

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: -- Initialize API return status to success
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: -- make sure record to be updated exists.
137: SELECT count(quota_category_id)
138: INTO l_count

Line 144: RAISE FND_API.G_EXC_ERROR;

140: WHERE quota_category_id = p_rec.quota_category_id;
141: IF (l_count = 0) THEN
142: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');
143: FND_MSG_PUB.ADD;
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147: -- check whether this quota_category_id is already assigned
148: -- cn_role_quota_cates table

Line 163: RAISE FND_API.G_EXC_ERROR;

159:
160: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
161: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', l_old_name);
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: l_newrec.quota_category_id := p_rec.quota_category_id;
167: l_newrec.name := p_rec.name;

Line 179: IF FND_API.To_Boolean( p_commit ) THEN

175: -- make sure the object version number hasn't changed in the meantime
176: cn_quota_categories_pkg.lock_update_row(l_newrec);
177:
178: -- Standard check of p_commit.
179: IF FND_API.To_Boolean( p_commit ) THEN
180: COMMIT WORK;
181: END IF;
182:
183: FND_MSG_PUB.Count_And_Get(

Line 186: p_encoded => FND_API.G_FALSE);

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

Line 188: WHEN FND_API.G_EXC_ERROR THEN

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

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 194: p_encoded => FND_API.G_FALSE);

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

Line 195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 201: p_encoded => FND_API.G_FALSE);

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

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 211: p_encoded => FND_API.G_FALSE);

207: END IF;
208: FND_MSG_PUB.Count_And_Get(
209: p_count => x_msg_count,
210: p_data => x_msg_data,
211: p_encoded => FND_API.G_FALSE);
212: END Update_Quota_Category;
213:
214: PROCEDURE Delete_Quota_Category(
215: p_api_version IN NUMBER,

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

212: END Update_Quota_Category;
213:
214: PROCEDURE Delete_Quota_Category(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_quota_category_id IN NUMBER,
220: p_object_version_number IN NUMBER,

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

213:
214: PROCEDURE Delete_Quota_Category(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_quota_category_id IN NUMBER,
220: p_object_version_number IN NUMBER,
221: x_return_status OUT NOCOPY VARCHAR2,

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

214: PROCEDURE Delete_Quota_Category(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_quota_category_id IN NUMBER,
220: p_object_version_number IN NUMBER,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,

Line 234: IF NOT FND_API.Compatible_API_Call

230:
231: -- Standard Start of API savepoint
232: SAVEPOINT Delete_Quota_Category;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call
235: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: SAVEPOINT Delete_Quota_Category;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call
235: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE.
240: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 240: IF FND_API.to_Boolean( p_init_msg_list ) THEN

236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: -- Initialize message list if p_init_msg_list is set to TRUE.
240: IF FND_API.to_Boolean( p_init_msg_list ) THEN
241: FND_MSG_PUB.initialize;
242: END IF;
243:
244: -- Initialize API return status to success

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: FND_MSG_PUB.initialize;
242: END IF;
243:
244: -- Initialize API return status to success
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: -- make sure record to be deleted exists.
247: SELECT count(quota_category_id)
248: INTO l_count
249: FROM cn_quota_categories

Line 254: RAISE FND_API.G_EXC_ERROR;

250: WHERE quota_category_id = p_quota_category_id;
251: IF (l_count = 0) THEN
252: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DELETE_REC');
253: FND_MSG_PUB.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256: -- check whether this quota_category_id is already assigned
257: -- cn_role_quota_cates table
258: SELECT count(quota_category_id)

Line 272: RAISE FND_API.G_EXC_ERROR ;

268:
269: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
270: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', qc_name);
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR ;
273: END IF;
274:
275: -- make sure the object version number hasn't changed in the meantime
276: cn_quota_categories_pkg.delete_row(p_quota_category_id);

Line 279: IF FND_API.To_Boolean( p_commit ) THEN

275: -- make sure the object version number hasn't changed in the meantime
276: cn_quota_categories_pkg.delete_row(p_quota_category_id);
277:
278: -- Standard check of p_commit.
279: IF FND_API.To_Boolean( p_commit ) THEN
280: COMMIT WORK;
281: END IF;
282:
283: FND_MSG_PUB.Count_And_Get(

Line 286: p_encoded => FND_API.G_FALSE);

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

Line 288: WHEN FND_API.G_EXC_ERROR THEN

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

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 294: p_encoded => FND_API.G_FALSE);

290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MSG_PUB.Count_And_Get(
292: p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => FND_API.G_FALSE);
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: ROLLBACK TO Delete_Quota_Category;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get(

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 301: p_encoded => FND_API.G_FALSE);

297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get(
299: p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => FND_API.G_FALSE);
302: WHEN OTHERS THEN
303: ROLLBACK TO Delete_Quota_Category;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300: p_data => x_msg_data,
301: p_encoded => FND_API.G_FALSE);
302: WHEN OTHERS THEN
303: ROLLBACK TO Delete_Quota_Category;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: IF FND_MSG_PUB.Check_Msg_Level(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 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: END Delete_Quota_Category;
313:
314: PROCEDURE get_quota_category_details
315: ( p_api_version IN NUMBER,

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

312: END Delete_Quota_Category;
313:
314: PROCEDURE get_quota_category_details
315: ( p_api_version IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318:
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,

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

313:
314: PROCEDURE get_quota_category_details
315: ( p_api_version IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318:
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,

Line 360: IF NOT FND_API.compatible_api_call

356: BEGIN
357: --
358: -- Standard call to check for call compatibility.
359: --
360: IF NOT FND_API.compatible_api_call
361: ( l_api_version ,p_api_version ,l_api_name,G_PKG_NAME )
362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: --
360: IF NOT FND_API.compatible_api_call
361: ( l_api_version ,p_api_version ,l_api_name,G_PKG_NAME )
362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: --
367: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 369: IF FND_API.to_Boolean( p_init_msg_list ) THEN

365:
366: --
367: -- Initialize message list if p_init_msg_list is set to TRUE.
368: --
369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: --

Line 376: x_return_status := FND_API.G_RET_STS_SUCCESS;

372:
373: --
374: -- Initialize API return status to success
375: --
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377:
378: --
379: -- API body
380: --

Line 430: WHEN FND_API.G_EXC_ERROR THEN

426: l_counter := l_counter + 1;
427: END LOOP;
428:
429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: FND_MSG_PUB.Count_And_Get
433: (
434: p_count => x_msg_count ,

Line 431: x_return_status := FND_API.G_RET_STS_ERROR ;

427: END LOOP;
428:
429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: FND_MSG_PUB.Count_And_Get
433: (
434: p_count => x_msg_count ,
435: p_data => x_msg_data ,

Line 436: p_encoded => FND_API.G_FALSE

432: FND_MSG_PUB.Count_And_Get
433: (
434: p_count => x_msg_count ,
435: p_data => x_msg_data ,
436: p_encoded => FND_API.G_FALSE
437: );
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get

Line 438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

434: p_count => x_msg_count ,
435: p_data => x_msg_data ,
436: p_encoded => FND_API.G_FALSE
437: );
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count ,

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

435: p_data => x_msg_data ,
436: p_encoded => FND_API.G_FALSE
437: );
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,

Line 444: p_encoded => FND_API.G_FALSE

440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE
445: );
446: WHEN OTHERS THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE
445: );
446: WHEN OTHERS THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
451: END IF;

Line 456: p_encoded => FND_API.G_FALSE

452: FND_MSG_PUB.Count_And_Get
453: (
454: p_count => x_msg_count ,
455: p_data => x_msg_data ,
456: p_encoded => FND_API.G_FALSE
457: );
458: END;
459:
460: END cn_quota_categories_pub;