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

Line 64: FND_MSG_PUB.initialize;

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

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

68: -- API body
69:
70: IF ( p_attain_schedule.name is NULL )
71: THEN
72: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
73: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
74: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
75: 'Attain Schedule Name');
76: FND_MSG_PUB.Add;

Line 76: FND_MSG_PUB.Add;

72: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
73: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
74: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
75: 'Attain Schedule Name');
76: FND_MSG_PUB.Add;
77: END IF;
78: RAISE FND_API.G_EXC_ERROR ;
79: END IF;
80:

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

86: WHERE name = p_attain_schedule.name
87: ;
88:
89: IF l_temp_count > 0 THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
92: FND_MSG_PUB.Add;
93: END IF;
94: RAISE FND_API.G_EXC_ERROR ;

Line 92: FND_MSG_PUB.Add;

88:
89: IF l_temp_count > 0 THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
92: FND_MSG_PUB.Add;
93: END IF;
94: RAISE FND_API.G_EXC_ERROR ;
95: END IF;
96:

Line 136: FND_MSG_PUB.Count_And_Get

132: IF FND_API.To_Boolean( p_commit ) THEN
133: COMMIT WORK;
134: END IF;
135: -- Standard call to get message count and if count is 1, get message info.
136: FND_MSG_PUB.Count_And_Get
137: (p_count => x_msg_count ,
138: p_data => x_msg_data ,
139: p_encoded => FND_API.G_FALSE );
140: EXCEPTION

Line 144: FND_MSG_PUB.Count_And_Get

140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO Create_Attain_Schedule;
143: x_return_status := FND_API.G_RET_STS_ERROR ;
144: FND_MSG_PUB.Count_And_Get
145: (p_count => x_msg_count ,
146: p_data => x_msg_data ,
147: p_encoded => FND_API.G_FALSE );
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 151: FND_MSG_PUB.Count_And_Get

147: p_encoded => FND_API.G_FALSE );
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: ROLLBACK TO Create_Attain_Schedule;
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: FND_MSG_PUB.Count_And_Get
152: (p_count => x_msg_count ,
153: p_data => x_msg_data ,
154: p_encoded => FND_API.G_FALSE );
155: WHEN OTHERS THEN

Line 158: IF FND_MSG_PUB.Check_Msg_Level

154: p_encoded => FND_API.G_FALSE );
155: WHEN OTHERS THEN
156: ROLLBACK TO Create_Attain_Schedule;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level
159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,

Line 159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

155: WHEN OTHERS THEN
156: ROLLBACK TO Create_Attain_Schedule;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level
159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,
163: l_api_name );

Line 161: FND_MSG_PUB.Add_Exc_Msg

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level
159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,
163: l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get

Line 165: FND_MSG_PUB.Count_And_Get

161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,
163: l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get
166: (p_count => x_msg_count ,
167: p_data => x_msg_data ,
168: p_encoded => FND_API.G_FALSE );
169: END Create_Attain_Schedule;

Line 234: FND_MSG_PUB.initialize;

230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: END IF;
232: -- Initialize message list if p_init_msg_list is set to TRUE.
233: IF FND_API.to_Boolean( p_init_msg_list ) THEN
234: FND_MSG_PUB.initialize;
235: END IF;
236: -- Initialize API return status to success
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: -- API body

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

239:
240: IF ( p_attain_schedule.attain_schedule_id is NULL ) OR
241: ( p_attain_schedule.name is NULL )
242: THEN
243: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
244: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
245: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
246: 'Attain Schedule ID or Name');
247: FND_MSG_PUB.Add;

Line 247: FND_MSG_PUB.Add;

243: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
244: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
245: FND_MESSAGE.SET_TOKEN('INPUT_NAME',
246: 'Attain Schedule ID or Name');
247: FND_MSG_PUB.Add;
248: END IF;
249: RAISE FND_API.G_EXC_ERROR ;
250: END IF;
251:

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

257: WHERE name = p_attain_schedule.name
258: AND attain_schedule_id <> p_attain_schedule.attain_schedule_id;
259:
260: IF l_temp_count > 0 THEN
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
262: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
263: FND_MSG_PUB.Add;
264: END IF;
265: RAISE FND_API.G_EXC_ERROR ;

Line 263: FND_MSG_PUB.Add;

259:
260: IF l_temp_count > 0 THEN
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
262: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
263: FND_MSG_PUB.Add;
264: END IF;
265: RAISE FND_API.G_EXC_ERROR ;
266: END IF;
267:

Line 276: fnd_msg_pub.add;

272: -- check object version number
273: IF l_old_attain_schedule.object_version_number <>
274: p_attain_schedule.object_version_number THEN
275: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
276: fnd_msg_pub.add;
277: raise fnd_api.g_exc_error;
278: END IF;
279:
280: CN_ATTAIN_SCHEDULES_PKG.UPDATE_ROW

Line 312: FND_MSG_PUB.Count_And_Get

308: IF FND_API.To_Boolean( p_commit ) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: (p_count => x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => FND_API.G_FALSE );
316: EXCEPTION

Line 320: FND_MSG_PUB.Count_And_Get

316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO Update_Attain_Schedule;
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: FND_MSG_PUB.Count_And_Get
321: (p_count => x_msg_count ,
322: p_data => x_msg_data ,
323: p_encoded => FND_API.G_FALSE );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 327: FND_MSG_PUB.Count_And_Get

323: p_encoded => FND_API.G_FALSE );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO Update_Attain_Schedule;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: FND_MSG_PUB.Count_And_Get
328: (p_count => x_msg_count ,
329: p_data => x_msg_data ,
330: p_encoded => FND_API.G_FALSE );
331: WHEN OTHERS THEN

Line 334: IF FND_MSG_PUB.Check_Msg_Level

330: p_encoded => FND_API.G_FALSE );
331: WHEN OTHERS THEN
332: ROLLBACK TO Update_Attain_Schedule;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: IF FND_MSG_PUB.Check_Msg_Level
335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: (G_PKG_NAME ,

Line 335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

331: WHEN OTHERS THEN
332: ROLLBACK TO Update_Attain_Schedule;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: IF FND_MSG_PUB.Check_Msg_Level
335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: (G_PKG_NAME ,
339: l_api_name );

Line 337: FND_MSG_PUB.Add_Exc_Msg

333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: IF FND_MSG_PUB.Check_Msg_Level
335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: (G_PKG_NAME ,
339: l_api_name );
340: END IF;
341: FND_MSG_PUB.Count_And_Get

Line 341: FND_MSG_PUB.Count_And_Get

337: FND_MSG_PUB.Add_Exc_Msg
338: (G_PKG_NAME ,
339: l_api_name );
340: END IF;
341: FND_MSG_PUB.Count_And_Get
342: (p_count => x_msg_count ,
343: p_data => x_msg_data ,
344: p_encoded => FND_API.G_FALSE );
345: END Update_Attain_Schedule;

Line 405: FND_MSG_PUB.initialize;

401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean( p_init_msg_list ) THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: -- API body

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

416: WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id
417: AND rownum = 1;
418:
419: IF l_temp_count > 0 THEN
420: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
421: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANT_DELETE');
422: FND_MSG_PUB.Add;
423: END IF;
424: RAISE FND_API.G_EXC_ERROR ;

Line 422: FND_MSG_PUB.Add;

418:
419: IF l_temp_count > 0 THEN
420: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
421: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANT_DELETE');
422: FND_MSG_PUB.Add;
423: END IF;
424: RAISE FND_API.G_EXC_ERROR ;
425: END IF;
426:

Line 458: FND_MSG_PUB.Count_And_Get

454: IF FND_API.To_Boolean( p_commit ) THEN
455: COMMIT WORK;
456: END IF;
457: -- Standard call to get message count and if count is 1, get message info.
458: FND_MSG_PUB.Count_And_Get
459: (p_count => x_msg_count ,
460: p_data => x_msg_data ,
461: p_encoded => FND_API.G_FALSE );
462: EXCEPTION

Line 466: FND_MSG_PUB.Count_And_Get

462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK TO Delete_Attain_Schedule;
465: x_return_status := FND_API.G_RET_STS_ERROR ;
466: FND_MSG_PUB.Count_And_Get
467: (p_count => x_msg_count ,
468: p_data => x_msg_data ,
469: p_encoded => FND_API.G_FALSE );
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 473: FND_MSG_PUB.Count_And_Get

469: p_encoded => FND_API.G_FALSE );
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: ROLLBACK TO Delete_Attain_Schedule;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
473: FND_MSG_PUB.Count_And_Get
474: (p_count => x_msg_count ,
475: p_data => x_msg_data ,
476: p_encoded => FND_API.G_FALSE );
477: WHEN OTHERS THEN

Line 480: IF FND_MSG_PUB.Check_Msg_Level

476: p_encoded => FND_API.G_FALSE );
477: WHEN OTHERS THEN
478: ROLLBACK TO Delete_Attain_Schedule;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: IF FND_MSG_PUB.Check_Msg_Level
481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
482: THEN
483: FND_MSG_PUB.Add_Exc_Msg
484: (G_PKG_NAME ,

Line 481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

477: WHEN OTHERS THEN
478: ROLLBACK TO Delete_Attain_Schedule;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: IF FND_MSG_PUB.Check_Msg_Level
481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
482: THEN
483: FND_MSG_PUB.Add_Exc_Msg
484: (G_PKG_NAME ,
485: l_api_name );

Line 483: FND_MSG_PUB.Add_Exc_Msg

479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: IF FND_MSG_PUB.Check_Msg_Level
481: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
482: THEN
483: FND_MSG_PUB.Add_Exc_Msg
484: (G_PKG_NAME ,
485: l_api_name );
486: END IF;
487: FND_MSG_PUB.Count_And_Get

Line 487: FND_MSG_PUB.Count_And_Get

483: FND_MSG_PUB.Add_Exc_Msg
484: (G_PKG_NAME ,
485: l_api_name );
486: END IF;
487: FND_MSG_PUB.Count_And_Get
488: (p_count => x_msg_count ,
489: p_data => x_msg_data ,
490: p_encoded => FND_API.G_FALSE );
491: END Delete_Attain_Schedule;

Line 552: FND_MSG_PUB.initialize;

548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END IF;
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF FND_API.to_Boolean( p_init_msg_list ) THEN
552: FND_MSG_PUB.initialize;
553: END IF;
554: -- Initialize API return status to success
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: -- API body

Line 587: FND_MSG_PUB.Count_And_Get

583: IF FND_API.To_Boolean( p_commit ) THEN
584: COMMIT WORK;
585: END IF;
586: -- Standard call to get message count and if count is 1, get message info.
587: FND_MSG_PUB.Count_And_Get
588: (p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE );
591: EXCEPTION

Line 595: FND_MSG_PUB.Count_And_Get

591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO Get_Attain_Schedule;
594: x_return_status := FND_API.G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 602: FND_MSG_PUB.Count_And_Get

598: p_encoded => FND_API.G_FALSE );
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: ROLLBACK TO Get_Attain_Schedule;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
602: FND_MSG_PUB.Count_And_Get
603: (p_count => x_msg_count ,
604: p_data => x_msg_data ,
605: p_encoded => FND_API.G_FALSE );
606: WHEN OTHERS THEN

Line 609: IF FND_MSG_PUB.Check_Msg_Level

605: p_encoded => FND_API.G_FALSE );
606: WHEN OTHERS THEN
607: ROLLBACK TO Get_Attain_Schedule;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF FND_MSG_PUB.Check_Msg_Level
610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: FND_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME ,

Line 610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

606: WHEN OTHERS THEN
607: ROLLBACK TO Get_Attain_Schedule;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF FND_MSG_PUB.Check_Msg_Level
610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: FND_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME ,
614: l_api_name );

Line 612: FND_MSG_PUB.Add_Exc_Msg

608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF FND_MSG_PUB.Check_Msg_Level
610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: FND_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME ,
614: l_api_name );
615: END IF;
616: FND_MSG_PUB.Count_And_Get

Line 616: FND_MSG_PUB.Count_And_Get

612: FND_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME ,
614: l_api_name );
615: END IF;
616: FND_MSG_PUB.Count_And_Get
617: (p_count => x_msg_count ,
618: p_data => x_msg_data ,
619: p_encoded => FND_API.G_FALSE );
620: END Get_Attain_Schedule;