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_ATTAIN_TIER_PVT dependencies on FND_MSG_PUB

Line 66: FND_MSG_PUB.initialize;

62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68: -- Initialize API return status to success
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70: -- API body

Line 75: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

71:
72: IF ( p_attain_tier.attain_schedule_id is NULL ) OR
73: ( p_attain_tier.percent is NULL )
74: THEN
75: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
76: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
77: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
78: 'Attain Schedule, Attain Tier or Percentage Amount');
79: FND_MSG_PUB.Add;

Line 79: FND_MSG_PUB.Add;

75: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
76: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
77: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
78: 'Attain Schedule, Attain Tier or Percentage Amount');
79: FND_MSG_PUB.Add;
80: END IF;
81: RAISE FND_API.G_EXC_ERROR ;
82: END IF;
83:

Line 94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

90: AND percent = p_attain_tier.percent
91: ;
92:
93: IF l_temp_count > 0 THEN
94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
95: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
96: FND_MSG_PUB.Add;
97: END IF;
98: RAISE FND_API.G_EXC_ERROR ;

Line 96: FND_MSG_PUB.Add;

92:
93: IF l_temp_count > 0 THEN
94: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
95: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
96: FND_MSG_PUB.Add;
97: END IF;
98: RAISE FND_API.G_EXC_ERROR ;
99: END IF;
100:

Line 102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

98: RAISE FND_API.G_EXC_ERROR ;
99: END IF;
100:
101: IF p_attain_tier.percent < 0 THEN
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
103: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_INPUT');
104: FND_MSG_PUB.Add;
105: END IF;
106: RAISE FND_API.G_EXC_ERROR ;

Line 104: FND_MSG_PUB.Add;

100:
101: IF p_attain_tier.percent < 0 THEN
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
103: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_INPUT');
104: FND_MSG_PUB.Add;
105: END IF;
106: RAISE FND_API.G_EXC_ERROR ;
107: END IF;
108:

Line 149: FND_MSG_PUB.Count_And_Get

145: IF FND_API.To_Boolean( p_commit ) THEN
146: COMMIT WORK;
147: END IF;
148: -- Standard call to get message count and if count is 1, get message info.
149: FND_MSG_PUB.Count_And_Get
150: (p_count => x_msg_count ,
151: p_data => x_msg_data ,
152: p_encoded => FND_API.G_FALSE );
153: EXCEPTION

Line 157: FND_MSG_PUB.Count_And_Get

153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO Create_Attain_Tier;
156: x_return_status := FND_API.G_RET_STS_ERROR ;
157: FND_MSG_PUB.Count_And_Get
158: (p_count => x_msg_count ,
159: p_data => x_msg_data ,
160: p_encoded => FND_API.G_FALSE );
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 164: FND_MSG_PUB.Count_And_Get

160: p_encoded => FND_API.G_FALSE );
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO Create_Attain_Tier;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: FND_MSG_PUB.Count_And_Get
165: (p_count => x_msg_count ,
166: p_data => x_msg_data ,
167: p_encoded => FND_API.G_FALSE );
168: WHEN OTHERS THEN

Line 171: IF FND_MSG_PUB.Check_Msg_Level

167: p_encoded => FND_API.G_FALSE );
168: WHEN OTHERS THEN
169: ROLLBACK TO Create_Attain_Tier;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg
175: (G_PKG_NAME ,

Line 172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

168: WHEN OTHERS THEN
169: ROLLBACK TO Create_Attain_Tier;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg
175: (G_PKG_NAME ,
176: l_api_name );

Line 174: FND_MSG_PUB.Add_Exc_Msg

170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg
175: (G_PKG_NAME ,
176: l_api_name );
177: END IF;
178: FND_MSG_PUB.Count_And_Get

Line 178: FND_MSG_PUB.Count_And_Get

174: FND_MSG_PUB.Add_Exc_Msg
175: (G_PKG_NAME ,
176: l_api_name );
177: END IF;
178: FND_MSG_PUB.Count_And_Get
179: (p_count => x_msg_count ,
180: p_data => x_msg_data ,
181: p_encoded => FND_API.G_FALSE );
182: END Create_Attain_Tier;

Line 247: FND_MSG_PUB.initialize;

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

Line 257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

253: IF ( p_attain_tier.attain_tier_id is NULL ) OR
254: ( p_attain_tier.attain_schedule_id is NULL ) OR
255: ( p_attain_tier.percent is NULL )
256: THEN
257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
258: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
259: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
260: 'Attain Schedule, Attain Tier or Percentage Amount');
261: FND_MSG_PUB.Add;

Line 261: FND_MSG_PUB.Add;

257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
258: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
259: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
260: 'Attain Schedule, Attain Tier or Percentage Amount');
261: FND_MSG_PUB.Add;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR ;
264: END IF;
265:

Line 276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

272: AND percent = p_attain_tier.percent
273: AND attain_tier_id <> p_attain_tier.attain_tier_id;
274:
275: IF l_temp_count > 0 THEN
276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
277: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
278: FND_MSG_PUB.Add;
279: END IF;
280: RAISE FND_API.G_EXC_ERROR ;

Line 278: FND_MSG_PUB.Add;

274:
275: IF l_temp_count > 0 THEN
276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
277: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
278: FND_MSG_PUB.Add;
279: END IF;
280: RAISE FND_API.G_EXC_ERROR ;
281: END IF;
282:

Line 284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

280: RAISE FND_API.G_EXC_ERROR ;
281: END IF;
282:
283: IF p_attain_tier.percent < 0 THEN
284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_INPUT');
286: FND_MSG_PUB.Add;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR ;

Line 286: FND_MSG_PUB.Add;

282:
283: IF p_attain_tier.percent < 0 THEN
284: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_INPUT');
286: FND_MSG_PUB.Add;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR ;
289: END IF;
290:

Line 299: fnd_msg_pub.add;

295: -- check object version number
296: IF l_old_attain_tier.object_version_number <>
297: p_attain_tier.object_version_number THEN
298: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
299: fnd_msg_pub.add;
300: raise fnd_api.g_exc_error;
301: END IF;
302:
303: CN_ATTAIN_TIERS_PKG.UPDATE_ROW

Line 336: FND_MSG_PUB.Count_And_Get

332: IF FND_API.To_Boolean( p_commit ) THEN
333: COMMIT WORK;
334: END IF;
335: -- Standard call to get message count and if count is 1, get message info.
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count ,
338: p_data => x_msg_data ,
339: p_encoded => FND_API.G_FALSE );
340: EXCEPTION

Line 344: FND_MSG_PUB.Count_And_Get

340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Update_Attain_Tier;
343: x_return_status := FND_API.G_RET_STS_ERROR ;
344: FND_MSG_PUB.Count_And_Get
345: (p_count => x_msg_count ,
346: p_data => x_msg_data ,
347: p_encoded => FND_API.G_FALSE );
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 351: FND_MSG_PUB.Count_And_Get

347: p_encoded => FND_API.G_FALSE );
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Update_Attain_Tier;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.Count_And_Get
352: (p_count => x_msg_count ,
353: p_data => x_msg_data ,
354: p_encoded => FND_API.G_FALSE );
355: WHEN OTHERS THEN

Line 358: IF FND_MSG_PUB.Check_Msg_Level

354: p_encoded => FND_API.G_FALSE );
355: WHEN OTHERS THEN
356: ROLLBACK TO Update_Attain_Tier;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: IF FND_MSG_PUB.Check_Msg_Level
359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: FND_MSG_PUB.Add_Exc_Msg
362: (G_PKG_NAME ,

Line 359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

355: WHEN OTHERS THEN
356: ROLLBACK TO Update_Attain_Tier;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: IF FND_MSG_PUB.Check_Msg_Level
359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: FND_MSG_PUB.Add_Exc_Msg
362: (G_PKG_NAME ,
363: l_api_name );

Line 361: FND_MSG_PUB.Add_Exc_Msg

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: IF FND_MSG_PUB.Check_Msg_Level
359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: FND_MSG_PUB.Add_Exc_Msg
362: (G_PKG_NAME ,
363: l_api_name );
364: END IF;
365: FND_MSG_PUB.Count_And_Get

Line 365: FND_MSG_PUB.Count_And_Get

361: FND_MSG_PUB.Add_Exc_Msg
362: (G_PKG_NAME ,
363: l_api_name );
364: END IF;
365: FND_MSG_PUB.Count_And_Get
366: (p_count => x_msg_count ,
367: p_data => x_msg_data ,
368: p_encoded => FND_API.G_FALSE );
369: END Update_Attain_Tier;

Line 419: FND_MSG_PUB.initialize;

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: -- Initialize message list if p_init_msg_list is set to TRUE.
418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421: -- Initialize API return status to success
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423: -- API body

Line 434: FND_MSG_PUB.Count_And_Get

430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT WORK;
432: END IF;
433: -- Standard call to get message count and if count is 1, get message info.
434: FND_MSG_PUB.Count_And_Get
435: (p_count => x_msg_count ,
436: p_data => x_msg_data ,
437: p_encoded => FND_API.G_FALSE );
438: EXCEPTION

Line 442: FND_MSG_PUB.Count_And_Get

438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: ROLLBACK TO Delete_Attain_Tier;
441: x_return_status := FND_API.G_RET_STS_ERROR ;
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count ,
444: p_data => x_msg_data ,
445: p_encoded => FND_API.G_FALSE );
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 449: FND_MSG_PUB.Count_And_Get

445: p_encoded => FND_API.G_FALSE );
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO Delete_Attain_Tier;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count ,
451: p_data => x_msg_data ,
452: p_encoded => FND_API.G_FALSE );
453: WHEN OTHERS THEN

Line 456: IF FND_MSG_PUB.Check_Msg_Level

452: p_encoded => FND_API.G_FALSE );
453: WHEN OTHERS THEN
454: ROLLBACK TO Delete_Attain_Tier;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: IF FND_MSG_PUB.Check_Msg_Level
457: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg
460: (G_PKG_NAME ,

Line 457: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

453: WHEN OTHERS THEN
454: ROLLBACK TO Delete_Attain_Tier;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: IF FND_MSG_PUB.Check_Msg_Level
457: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg
460: (G_PKG_NAME ,
461: l_api_name );

Line 459: FND_MSG_PUB.Add_Exc_Msg

455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: IF FND_MSG_PUB.Check_Msg_Level
457: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg
460: (G_PKG_NAME ,
461: l_api_name );
462: END IF;
463: FND_MSG_PUB.Count_And_Get

Line 463: FND_MSG_PUB.Count_And_Get

459: FND_MSG_PUB.Add_Exc_Msg
460: (G_PKG_NAME ,
461: l_api_name );
462: END IF;
463: FND_MSG_PUB.Count_And_Get
464: (p_count => x_msg_count ,
465: p_data => x_msg_data ,
466: p_encoded => FND_API.G_FALSE );
467: END Delete_Attain_Tier;

Line 531: FND_MSG_PUB.initialize;

527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list ) THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533: -- Initialize API return status to success
534: x_return_status := FND_API.G_RET_STS_SUCCESS;
535: -- API body

Line 566: FND_MSG_PUB.Count_And_Get

562: IF FND_API.To_Boolean( p_commit ) THEN
563: COMMIT WORK;
564: END IF;
565: -- Standard call to get message count and if count is 1, get message info.
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data ,
569: p_encoded => FND_API.G_FALSE );
570: EXCEPTION

Line 574: FND_MSG_PUB.Count_And_Get

570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Get_Attain_Tier;
573: x_return_status := FND_API.G_RET_STS_ERROR ;
574: FND_MSG_PUB.Count_And_Get
575: (p_count => x_msg_count ,
576: p_data => x_msg_data ,
577: p_encoded => FND_API.G_FALSE );
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 581: FND_MSG_PUB.Count_And_Get

577: p_encoded => FND_API.G_FALSE );
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO Get_Attain_Tier;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
581: FND_MSG_PUB.Count_And_Get
582: (p_count => x_msg_count ,
583: p_data => x_msg_data ,
584: p_encoded => FND_API.G_FALSE );
585: WHEN OTHERS THEN

Line 588: IF FND_MSG_PUB.Check_Msg_Level

584: p_encoded => FND_API.G_FALSE );
585: WHEN OTHERS THEN
586: ROLLBACK TO Get_Attain_Tier;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
588: IF FND_MSG_PUB.Check_Msg_Level
589: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg
592: (G_PKG_NAME ,

Line 589: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

585: WHEN OTHERS THEN
586: ROLLBACK TO Get_Attain_Tier;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
588: IF FND_MSG_PUB.Check_Msg_Level
589: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg
592: (G_PKG_NAME ,
593: l_api_name );

Line 591: FND_MSG_PUB.Add_Exc_Msg

587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
588: IF FND_MSG_PUB.Check_Msg_Level
589: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg
592: (G_PKG_NAME ,
593: l_api_name );
594: END IF;
595: FND_MSG_PUB.Count_And_Get

Line 595: FND_MSG_PUB.Count_And_Get

591: FND_MSG_PUB.Add_Exc_Msg
592: (G_PKG_NAME ,
593: l_api_name );
594: END IF;
595: FND_MSG_PUB.Count_And_Get
596: (p_count => x_msg_count ,
597: p_data => x_msg_data ,
598: p_encoded => FND_API.G_FALSE );
599: END Get_Attain_Tier;