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_MSG_PUB

Line 38: FND_MSG_PUB.initialize;

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;
42:

Line 57: FND_MSG_PUB.Add;

53: FROM cn_quota_categories
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);

Line 66: FND_MSG_PUB.Count_And_Get(

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,
68: p_data => x_msg_data,
69: p_encoded => FND_API.G_FALSE);
70: EXCEPTION

Line 74: FND_MSG_PUB.Count_And_Get(

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);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 81: FND_MSG_PUB.Count_And_Get(

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);
85: WHEN OTHERS THEN

Line 88: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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(
92: p_count => x_msg_count,

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

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(
92: p_count => x_msg_count,
93: p_data => x_msg_data,

Line 91: FND_MSG_PUB.Count_And_Get(

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(
92: p_count => x_msg_count,
93: p_data => x_msg_data,
94: p_encoded => FND_API.G_FALSE);
95: END Create_Quota_Category;

Line 130: FND_MSG_PUB.initialize;

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
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 143: FND_MSG_PUB.ADD;

139: FROM cn_quota_categories
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

Line 162: FND_MSG_PUB.ADD;

158: WHERE quota_category_id = p_rec.quota_category_id;
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;

Line 183: FND_MSG_PUB.Count_And_Get(

179: IF FND_API.To_Boolean( p_commit ) THEN
180: COMMIT WORK;
181: END IF;
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

Line 191: FND_MSG_PUB.Count_And_Get(

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);
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 198: FND_MSG_PUB.Count_And_Get(

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);
202: WHEN OTHERS THEN

Line 205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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(
209: p_count => x_msg_count,

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

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(
209: p_count => x_msg_count,
210: p_data => x_msg_data,

Line 208: FND_MSG_PUB.Count_And_Get(

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(
209: p_count => x_msg_count,
210: p_data => x_msg_data,
211: p_encoded => FND_API.G_FALSE);
212: END Update_Quota_Category;

Line 241: FND_MSG_PUB.initialize;

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
245: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 253: FND_MSG_PUB.ADD;

249: FROM cn_quota_categories
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

Line 271: FND_MSG_PUB.ADD;

267: WHERE quota_category_id = p_quota_category_id;
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

Line 283: FND_MSG_PUB.Count_And_Get(

279: IF FND_API.To_Boolean( p_commit ) THEN
280: COMMIT WORK;
281: END IF;
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

Line 291: FND_MSG_PUB.Count_And_Get(

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);
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 298: FND_MSG_PUB.Count_And_Get(

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);
302: WHEN OTHERS THEN

Line 305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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(
309: p_count => x_msg_count,

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

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(
309: p_count => x_msg_count,
310: p_data => x_msg_data,

Line 308: FND_MSG_PUB.Count_And_Get(

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(
309: p_count => x_msg_count,
310: p_data => x_msg_data,
311: p_encoded => FND_API.G_FALSE);
312: END Delete_Quota_Category;

Line 370: FND_MSG_PUB.initialize;

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: --
374: -- Initialize API return status to success

Line 432: FND_MSG_PUB.Count_And_Get

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 ,
436: p_encoded => FND_API.G_FALSE

Line 440: FND_MSG_PUB.Count_And_Get

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 ,
444: p_encoded => FND_API.G_FALSE

Line 448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
452: FND_MSG_PUB.Count_And_Get

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

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;
452: FND_MSG_PUB.Count_And_Get
453: (
454: p_count => x_msg_count ,

Line 452: FND_MSG_PUB.Count_And_Get

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