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_API

Line 14: -- Default = FND_API.G_FALSE

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- IN : p_api_version IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 16: -- Default = FND_API.G_FALSE

12: -- IN : p_api_version IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- p_attain_schedule IN attain_schedule_rec_type
20: -- OUT : x_return_status OUT VARCHAR2(1)

Line 18: -- Default = FND_API.G_VALID_LEVEL_FULL

14: -- Default = FND_API.G_FALSE
15: -- p_commit IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_validation_level IN NUMBER Optional
18: -- Default = FND_API.G_VALID_LEVEL_FULL
19: -- p_attain_schedule IN attain_schedule_rec_type
20: -- OUT : x_return_status OUT VARCHAR2(1)
21: -- x_msg_count OUT NUMBER
22: -- x_msg_data OUT VARCHAR2(2000)

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

25: --
26: -- End of comments
27: PROCEDURE Create_Attain_Schedule
28: (p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_attain_schedule IN attain_schedule_rec_type,
33: x_return_status OUT NOCOPY VARCHAR2,

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

26: -- End of comments
27: PROCEDURE Create_Attain_Schedule
28: (p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_attain_schedule IN attain_schedule_rec_type,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,

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

27: PROCEDURE Create_Attain_Schedule
28: (p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_attain_schedule IN attain_schedule_rec_type,
33: x_return_status OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2

Line 54: IF NOT FND_API.Compatible_API_Call

50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT Create_Attain_Schedule;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call
55: (l_api_version ,
56: p_api_version ,
57: l_api_name ,
58: G_PKG_NAME )

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: p_api_version ,
57: l_api_name ,
58: G_PKG_NAME )
59: THEN
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;

Line 63: IF FND_API.to_Boolean( p_init_msg_list ) THEN

59: THEN
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;

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
69:
70: IF ( p_attain_schedule.name is NULL )
71: THEN

Line 78: RAISE FND_API.G_EXC_ERROR ;

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:
81: -- same role quota category is not allowed to be
82: -- assigned twice

Line 94: RAISE FND_API.G_EXC_ERROR ;

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:
97: select cn_role_quota_formulas_s.nextval
98: into l_attain_schedule_id

Line 132: IF FND_API.To_Boolean( p_commit ) THEN

128: );
129:
130: -- End of API body.
131: -- Standard check of p_commit.
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

Line 139: p_encoded => FND_API.G_FALSE );

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
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO Create_Attain_Schedule;
143: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137: (p_count => x_msg_count ,
138: p_data => x_msg_data ,
139: p_encoded => FND_API.G_FALSE );
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 ,

Line 143: x_return_status := FND_API.G_RET_STS_ERROR ;

139: p_encoded => FND_API.G_FALSE );
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 );

Line 147: p_encoded => FND_API.G_FALSE );

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
149: ROLLBACK TO Create_Attain_Schedule;
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: FND_MSG_PUB.Count_And_Get

Line 148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

146: p_data => x_msg_data ,
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 );

Line 154: p_encoded => FND_API.G_FALSE );

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

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

153: p_data => x_msg_data ,
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

Line 168: p_encoded => FND_API.G_FALSE );

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;
170:
171:
172: -- Start of comments

Line 180: -- Default = FND_API.G_FALSE

176: -- Pre-reqs : None.
177: -- Parameters :
178: -- IN : p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional
180: -- Default = FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Optional
182: -- Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional
184: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 182: -- Default = FND_API.G_FALSE

178: -- IN : p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Optional
180: -- Default = FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Optional
182: -- Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional
184: -- Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_attain_schedule IN attain_schedule_rec_type
186: -- OUT : x_return_status OUT VARCHAR2(1)

Line 184: -- Default = FND_API.G_VALID_LEVEL_FULL

180: -- Default = FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Optional
182: -- Default = FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Optional
184: -- Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_attain_schedule IN attain_schedule_rec_type
186: -- OUT : x_return_status OUT VARCHAR2(1)
187: -- x_msg_count OUT NUMBER
188: -- x_msg_data OUT VARCHAR2(2000)

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

191: --
192: -- End of comments
193: PROCEDURE Update_Attain_Schedule
194: (p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_attain_schedule IN attain_schedule_rec_type,
199: x_return_status OUT NOCOPY VARCHAR2,

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

192: -- End of comments
193: PROCEDURE Update_Attain_Schedule
194: (p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_attain_schedule IN attain_schedule_rec_type,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,

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

193: PROCEDURE Update_Attain_Schedule
194: (p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: p_attain_schedule IN attain_schedule_rec_type,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2

Line 224: IF NOT FND_API.Compatible_API_Call

220: BEGIN
221: -- Standard Start of API savepoint
222: SAVEPOINT Update_Attain_Schedule;
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call
225: (l_api_version ,
226: p_api_version ,
227: l_api_name ,
228: G_PKG_NAME )

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: p_api_version ,
227: l_api_name ,
228: G_PKG_NAME )
229: THEN
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;

Line 233: IF FND_API.to_Boolean( p_init_msg_list ) THEN

229: THEN
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;

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 )

Line 249: RAISE FND_API.G_EXC_ERROR ;

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:
252: -- same role quota category is not allowed to be
253: -- assigned twice

Line 265: RAISE FND_API.G_EXC_ERROR ;

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:
268: OPEN l_old_attain_schedule_cr;
269: FETCH l_old_attain_schedule_cr INTO l_old_attain_schedule;

Line 277: raise fnd_api.g_exc_error;

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
281: (

Line 308: IF FND_API.To_Boolean( p_commit ) THEN

304: );
305:
306: -- End of API body.
307: -- Standard check of p_commit.
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

Line 315: p_encoded => FND_API.G_FALSE );

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
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO Update_Attain_Schedule;
319: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: (p_count => x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => FND_API.G_FALSE );
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 ,

Line 319: x_return_status := FND_API.G_RET_STS_ERROR ;

315: p_encoded => FND_API.G_FALSE );
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 );

Line 323: p_encoded => FND_API.G_FALSE );

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
325: ROLLBACK TO Update_Attain_Schedule;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: FND_MSG_PUB.Count_And_Get

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

322: p_data => x_msg_data ,
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 );

Line 330: p_encoded => FND_API.G_FALSE );

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

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

329: p_data => x_msg_data ,
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

Line 344: p_encoded => FND_API.G_FALSE );

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;
346:
347:
348: -- Start of comments

Line 356: -- Default = FND_API.G_FALSE

352: -- Pre-reqs : None.
353: -- Parameters :
354: -- IN : p_api_version IN NUMBER Required
355: -- p_init_msg_list IN VARCHAR2 Optional
356: -- Default = FND_API.G_FALSE
357: -- p_commit IN VARCHAR2 Optional
358: -- Default = FND_API.G_FALSE
359: -- p_validation_level IN NUMBER Optional
360: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 358: -- Default = FND_API.G_FALSE

354: -- IN : p_api_version IN NUMBER Required
355: -- p_init_msg_list IN VARCHAR2 Optional
356: -- Default = FND_API.G_FALSE
357: -- p_commit IN VARCHAR2 Optional
358: -- Default = FND_API.G_FALSE
359: -- p_validation_level IN NUMBER Optional
360: -- Default = FND_API.G_VALID_LEVEL_FULL
361: -- p_attain_schedule IN attain_schedule_rec_type
362: -- OUT : x_return_status OUT VARCHAR2(1)

Line 360: -- Default = FND_API.G_VALID_LEVEL_FULL

356: -- Default = FND_API.G_FALSE
357: -- p_commit IN VARCHAR2 Optional
358: -- Default = FND_API.G_FALSE
359: -- p_validation_level IN NUMBER Optional
360: -- Default = FND_API.G_VALID_LEVEL_FULL
361: -- p_attain_schedule IN attain_schedule_rec_type
362: -- OUT : x_return_status OUT VARCHAR2(1)
363: -- x_msg_count OUT NUMBER
364: -- x_msg_data OUT VARCHAR2(2000)

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

367: --
368: -- End of comments
369: PROCEDURE Delete_Attain_Schedule
370: (p_api_version IN NUMBER,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372: p_commit IN VARCHAR2 := FND_API.G_FALSE,
373: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
374: p_attain_schedule IN attain_schedule_rec_type,
375: x_return_status OUT NOCOPY VARCHAR2,

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

368: -- End of comments
369: PROCEDURE Delete_Attain_Schedule
370: (p_api_version IN NUMBER,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372: p_commit IN VARCHAR2 := FND_API.G_FALSE,
373: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
374: p_attain_schedule IN attain_schedule_rec_type,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,

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

369: PROCEDURE Delete_Attain_Schedule
370: (p_api_version IN NUMBER,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372: p_commit IN VARCHAR2 := FND_API.G_FALSE,
373: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
374: p_attain_schedule IN attain_schedule_rec_type,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2

Line 395: IF NOT FND_API.Compatible_API_Call

391: BEGIN
392: -- Standard Start of API savepoint
393: SAVEPOINT Delete_Attain_Schedule;
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call
396: (l_api_version ,
397: p_api_version ,
398: l_api_name ,
399: G_PKG_NAME )

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

397: p_api_version ,
398: l_api_name ,
399: G_PKG_NAME )
400: THEN
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;

Line 404: IF FND_API.to_Boolean( p_init_msg_list ) THEN

400: THEN
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;

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
410:
411: -- do not allow to delete once assigned
412:

Line 424: RAISE FND_API.G_EXC_ERROR ;

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:
427:
428: CN_ATTAIN_SCHEDULES_PKG.DELETE_ROW(

Line 446: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

442: x_msg_count => x_msg_count,
443: x_msg_data => x_msg_data
444: );
445:
446: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
447: RAISE FND_API.G_EXC_ERROR ;
448: END IF;
449:
450: END LOOP;

Line 447: RAISE FND_API.G_EXC_ERROR ;

443: x_msg_data => x_msg_data
444: );
445:
446: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
447: RAISE FND_API.G_EXC_ERROR ;
448: END IF;
449:
450: END LOOP;
451:

Line 454: IF FND_API.To_Boolean( p_commit ) THEN

450: END LOOP;
451:
452: -- End of API body.
453: -- Standard check of p_commit.
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

Line 461: p_encoded => FND_API.G_FALSE );

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
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK TO Delete_Attain_Schedule;
465: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 463: WHEN FND_API.G_EXC_ERROR THEN

459: (p_count => x_msg_count ,
460: p_data => x_msg_data ,
461: p_encoded => FND_API.G_FALSE );
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 ,

Line 465: x_return_status := FND_API.G_RET_STS_ERROR ;

461: p_encoded => FND_API.G_FALSE );
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 );

Line 469: p_encoded => FND_API.G_FALSE );

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
471: ROLLBACK TO Delete_Attain_Schedule;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
473: FND_MSG_PUB.Count_And_Get

Line 470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

468: p_data => x_msg_data ,
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 );

Line 476: p_encoded => FND_API.G_FALSE );

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

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

475: p_data => x_msg_data ,
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

Line 490: p_encoded => FND_API.G_FALSE );

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;
492:
493:
494:

Line 503: -- Default = FND_API.G_FALSE

499: -- Pre-reqs : None.
500: -- Parameters :
501: -- IN : p_api_version IN NUMBER Required
502: -- p_init_msg_list IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_commit IN VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: -- p_validation_level IN NUMBER Optional
507: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 505: -- Default = FND_API.G_FALSE

501: -- IN : p_api_version IN NUMBER Required
502: -- p_init_msg_list IN VARCHAR2 Optional
503: -- Default = FND_API.G_FALSE
504: -- p_commit IN VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: -- p_validation_level IN NUMBER Optional
507: -- Default = FND_API.G_VALID_LEVEL_FULL
508: -- OUT : x_return_status OUT VARCHAR2(1)
509: -- x_msg_count OUT NUMBER

Line 507: -- Default = FND_API.G_VALID_LEVEL_FULL

503: -- Default = FND_API.G_FALSE
504: -- p_commit IN VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: -- p_validation_level IN NUMBER Optional
507: -- Default = FND_API.G_VALID_LEVEL_FULL
508: -- OUT : x_return_status OUT VARCHAR2(1)
509: -- x_msg_count OUT NUMBER
510: -- x_msg_data OUT VARCHAR2(2000)
511: -- x_attain_schedule OUT attain_schedule_tbl_type

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

514: --
515: -- End of comments
516: PROCEDURE Get_Attain_Schedule
517: (p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
521: x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
522: x_return_status OUT NOCOPY VARCHAR2,

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

515: -- End of comments
516: PROCEDURE Get_Attain_Schedule
517: (p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
521: x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,

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

516: PROCEDURE Get_Attain_Schedule
517: (p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
521: x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2

Line 542: IF NOT FND_API.Compatible_API_Call

538: BEGIN
539: -- Standard Start of API savepoint
540: SAVEPOINT Get_Attain_Schedule;
541: -- Standard call to check for call compatibility.
542: IF NOT FND_API.Compatible_API_Call
543: (l_api_version ,
544: p_api_version ,
545: l_api_name ,
546: G_PKG_NAME )

Line 548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

544: p_api_version ,
545: l_api_name ,
546: G_PKG_NAME )
547: THEN
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;

Line 551: IF FND_API.to_Boolean( p_init_msg_list ) THEN

547: THEN
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;

Line 555: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
557:
558: l_counter := 1;
559:

Line 583: IF FND_API.To_Boolean( p_commit ) THEN

579: CLOSE l_attain_schedule_cr;
580:
581: -- End of API body.
582: -- Standard check of p_commit.
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

Line 590: p_encoded => FND_API.G_FALSE );

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

Line 592: WHEN FND_API.G_EXC_ERROR THEN

588: (p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE );
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 ,

Line 594: x_return_status := FND_API.G_RET_STS_ERROR ;

590: p_encoded => FND_API.G_FALSE );
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 );

Line 598: p_encoded => FND_API.G_FALSE );

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
600: ROLLBACK TO Get_Attain_Schedule;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
602: FND_MSG_PUB.Count_And_Get

Line 599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

597: p_data => x_msg_data ,
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 );

Line 605: p_encoded => FND_API.G_FALSE );

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

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

604: p_data => x_msg_data ,
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

Line 619: p_encoded => FND_API.G_FALSE );

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;
621:
622: END CN_ATTAIN_SCHEDULE_PVT;