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
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;
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:
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 ;
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:
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
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
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
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 ,
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 );
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
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;
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
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;
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:
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 ;
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:
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
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
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
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
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 ,
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 );
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
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;
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
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 ;
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:
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
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
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
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 ,
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 );
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
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;
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
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
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
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
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 ,
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 );
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
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;