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_PLAN_TEXTS_PVT dependencies on FND_API

Line 28: RAISE fnd_api.g_exc_error;

24: IF (validate_role_state%found) THEN
25: CLOSE validate_role_state;
26: fnd_message.set_name('CN', 'CN_ROLE_DETAIL_ASGNED');
27: fnd_msg_pub.ADD;
28: RAISE fnd_api.g_exc_error;
29: END IF;
30: CLOSE validate_role_state;
31:
32: END ;

Line 42: -- Default = FND_API.G_FALSE

38: -- Pre-reqs : None.
39: -- Parameters :
40: -- IN : p_api_version IN NUMBER Required
41: -- p_init_msg_list IN VARCHAR2 Optional
42: -- Default = FND_API.G_FALSE
43: -- p_commit IN VARCHAR2 Optional
44: -- Default = FND_API.G_FALSE
45: -- p_validation_level IN NUMBER Optional
46: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 44: -- Default = FND_API.G_FALSE

40: -- IN : p_api_version IN NUMBER Required
41: -- p_init_msg_list IN VARCHAR2 Optional
42: -- Default = FND_API.G_FALSE
43: -- p_commit IN VARCHAR2 Optional
44: -- Default = FND_API.G_FALSE
45: -- p_validation_level IN NUMBER Optional
46: -- Default = FND_API.G_VALID_LEVEL_FULL
47: -- p_plan_text IN plan_text_rec_type
48: -- OUT : x_return_status OUT VARCHAR2(1)

Line 46: -- Default = FND_API.G_VALID_LEVEL_FULL

42: -- Default = FND_API.G_FALSE
43: -- p_commit IN VARCHAR2 Optional
44: -- Default = FND_API.G_FALSE
45: -- p_validation_level IN NUMBER Optional
46: -- Default = FND_API.G_VALID_LEVEL_FULL
47: -- p_plan_text IN plan_text_rec_type
48: -- OUT : x_return_status OUT VARCHAR2(1)
49: -- x_msg_count OUT NUMBER
50: -- x_msg_data OUT VARCHAR2(2000)

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

53: --
54: -- End of comments
55: PROCEDURE Create_Plan_Text (
56: p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_plan_text IN plan_text_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2,

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

54: -- End of comments
55: PROCEDURE Create_Plan_Text (
56: p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_plan_text IN plan_text_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,

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

55: PROCEDURE Create_Plan_Text (
56: p_api_version IN NUMBER,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_plan_text IN plan_text_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2

Line 82: IF NOT FND_API.Compatible_API_Call

78: BEGIN
79: -- Standard Start of API savepoint
80: SAVEPOINT Create_Plan_Text;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call
83: (l_api_version ,
84: p_api_version ,
85: l_api_name ,
86: G_PKG_NAME )

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: p_api_version ,
85: l_api_name ,
86: G_PKG_NAME )
87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;

Line 91: IF FND_API.to_Boolean( p_init_msg_list ) THEN

87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: IF FND_API.to_Boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: -- API body
97:
98: IF ( p_plan_text.role_id is NULL ) OR
99: ( p_plan_text.text_type is NULL )

Line 106: RAISE FND_API.G_EXC_ERROR ;

102: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
103: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'Role or Text Type');
104: FND_MSG_PUB.Add;
105: END IF;
106: RAISE FND_API.G_EXC_ERROR ;
107: END IF;
108:
109: -- CHECK THE ROLE SETUP
110:

Line 136: RAISE FND_API.G_EXC_ERROR ;

132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
134: FND_MSG_PUB.Add;
135: END IF;
136: RAISE FND_API.G_EXC_ERROR ;
137: END IF;
138:
139: SELECT cn_plan_texts_s.NEXTVAL INTO l_plan_text_id FROM DUAL;
140:

Line 161: IF FND_API.To_Boolean( p_commit ) THEN

157: );
158:
159: -- End of API body.
160: -- Standard check of p_commit.
161: IF FND_API.To_Boolean( p_commit ) THEN
162: COMMIT WORK;
163: END IF;
164: -- Standard call to get message count and if count is 1, get message info.
165: FND_MSG_PUB.Count_And_Get

Line 168: p_encoded => FND_API.G_FALSE );

164: -- Standard call to get message count and if count is 1, get message info.
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: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO Create_Plan_Text;
172: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 170: WHEN FND_API.G_EXC_ERROR THEN

166: (p_count => x_msg_count ,
167: p_data => x_msg_data ,
168: p_encoded => FND_API.G_FALSE );
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO Create_Plan_Text;
172: x_return_status := FND_API.G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: (p_count => x_msg_count ,

Line 172: x_return_status := FND_API.G_RET_STS_ERROR ;

168: p_encoded => FND_API.G_FALSE );
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO Create_Plan_Text;
172: x_return_status := FND_API.G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: (p_count => x_msg_count ,
175: p_data => x_msg_data ,
176: p_encoded => FND_API.G_FALSE );

Line 176: p_encoded => FND_API.G_FALSE );

172: x_return_status := FND_API.G_RET_STS_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: (p_count => x_msg_count ,
175: p_data => x_msg_data ,
176: p_encoded => FND_API.G_FALSE );
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO Create_Plan_Text;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: FND_MSG_PUB.Count_And_Get

Line 177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

173: FND_MSG_PUB.Count_And_Get
174: (p_count => x_msg_count ,
175: p_data => x_msg_data ,
176: p_encoded => FND_API.G_FALSE );
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO Create_Plan_Text;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

175: p_data => x_msg_data ,
176: p_encoded => FND_API.G_FALSE );
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO Create_Plan_Text;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,
182: p_data => x_msg_data ,
183: p_encoded => FND_API.G_FALSE );

Line 183: p_encoded => FND_API.G_FALSE );

179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,
182: p_data => x_msg_data ,
183: p_encoded => FND_API.G_FALSE );
184: WHEN OTHERS THEN
185: ROLLBACK TO Create_Plan_Text;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: IF FND_MSG_PUB.Check_Msg_Level

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

182: p_data => x_msg_data ,
183: p_encoded => FND_API.G_FALSE );
184: WHEN OTHERS THEN
185: ROLLBACK TO Create_Plan_Text;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: IF FND_MSG_PUB.Check_Msg_Level
188: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: FND_MSG_PUB.Add_Exc_Msg

Line 197: p_encoded => FND_API.G_FALSE );

193: END IF;
194: FND_MSG_PUB.Count_And_Get
195: (p_count => x_msg_count ,
196: p_data => x_msg_data ,
197: p_encoded => FND_API.G_FALSE );
198: END Create_Plan_Text;
199:
200:
201:

Line 210: -- Default = FND_API.G_FALSE

206: -- Pre-reqs : None.
207: -- Parameters :
208: -- IN : p_api_version IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 212: -- Default = FND_API.G_FALSE

208: -- IN : p_api_version IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_plan_text IN plan_text_rec_type
216: -- OUT : x_return_status OUT VARCHAR2(1)

Line 214: -- Default = FND_API.G_VALID_LEVEL_FULL

210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_plan_text IN plan_text_rec_type
216: -- OUT : x_return_status OUT VARCHAR2(1)
217: -- x_msg_count OUT NUMBER
218: -- x_msg_data OUT VARCHAR2(2000)

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

221: --
222: -- End of comments
223: PROCEDURE Update_Plan_Text (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_plan_text IN plan_text_rec_type,
229: x_return_status OUT NOCOPY VARCHAR2,

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

222: -- End of comments
223: PROCEDURE Update_Plan_Text (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_plan_text IN plan_text_rec_type,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,

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

223: PROCEDURE Update_Plan_Text (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: p_plan_text IN plan_text_rec_type,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2

Line 272: IF NOT FND_API.Compatible_API_Call

268: BEGIN
269: -- Standard Start of API savepoint
270: SAVEPOINT Update_Plan_Text;
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call
273: (l_api_version ,
274: p_api_version ,
275: l_api_name ,
276: G_PKG_NAME )

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: p_api_version ,
275: l_api_name ,
276: G_PKG_NAME )
277: THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;

Line 281: IF FND_API.to_Boolean( p_init_msg_list ) THEN

277: THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: -- Initialize message list if p_init_msg_list is set to TRUE.
281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284: -- Initialize API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 285: x_return_status := FND_API.G_RET_STS_SUCCESS;

281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284: -- Initialize API return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: -- API body
287:
288: IF ( p_plan_text.role_id is NULL ) OR
289: ( p_plan_text.text_type is NULL )

Line 296: RAISE FND_API.G_EXC_ERROR ;

292: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
293: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'Role or Text Type');
294: FND_MSG_PUB.Add;
295: END IF;
296: RAISE FND_API.G_EXC_ERROR ;
297: END IF;
298:
299: /*
300: OPEN validate_role_state(p_plan_text.role_id) ;

Line 306: RAISE fnd_api.g_exc_error;

302: IF (validate_role_state%found) THEN
303: CLOSE validate_role_state;
304: fnd_message.set_name('CN', 'CN_ROLE_DETAIL_ASGNED');
305: fnd_msg_pub.ADD;
306: RAISE fnd_api.g_exc_error;
307: END IF;
308: CLOSE validate_role_state;
309: */
310:

Line 336: RAISE FND_API.G_EXC_ERROR ;

332: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
333: FND_MESSAGE.SET_NAME ('CN' , 'CN_ASSIGN_CANT_SAME');
334: FND_MSG_PUB.Add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR ;
337: END IF;
338:
339: OPEN l_cr(p_plan_text.plan_text_id);
340: FETCH l_cr into l_plan_text;

Line 348: raise fnd_api.g_exc_error;

344: IF l_plan_text.object_version_number <>
345: p_plan_text.object_version_number THEN
346: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
347: fnd_msg_pub.add;
348: raise fnd_api.g_exc_error;
349: END IF;
350:
351: CN_PLAN_TEXTS_PKG.Update_Row
352: (

Line 385: IF FND_API.To_Boolean( p_commit ) THEN

381: );
382:
383: -- End of API body.
384: -- Standard check of p_commit.
385: IF FND_API.To_Boolean( p_commit ) THEN
386: COMMIT WORK;
387: END IF;
388: -- Standard call to get message count and if count is 1, get message info.
389: FND_MSG_PUB.Count_And_Get

Line 392: p_encoded => FND_API.G_FALSE );

388: -- Standard call to get message count and if count is 1, get message info.
389: FND_MSG_PUB.Count_And_Get
390: (p_count => x_msg_count ,
391: p_data => x_msg_data ,
392: p_encoded => FND_API.G_FALSE );
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: ROLLBACK TO Update_Plan_Text;
396: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 394: WHEN FND_API.G_EXC_ERROR THEN

390: (p_count => x_msg_count ,
391: p_data => x_msg_data ,
392: p_encoded => FND_API.G_FALSE );
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: ROLLBACK TO Update_Plan_Text;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get
398: (p_count => x_msg_count ,

Line 396: x_return_status := FND_API.G_RET_STS_ERROR ;

392: p_encoded => FND_API.G_FALSE );
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: ROLLBACK TO Update_Plan_Text;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get
398: (p_count => x_msg_count ,
399: p_data => x_msg_data ,
400: p_encoded => FND_API.G_FALSE );

Line 400: p_encoded => FND_API.G_FALSE );

396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get
398: (p_count => x_msg_count ,
399: p_data => x_msg_data ,
400: p_encoded => FND_API.G_FALSE );
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO Update_Plan_Text;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get

Line 401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

397: FND_MSG_PUB.Count_And_Get
398: (p_count => x_msg_count ,
399: p_data => x_msg_data ,
400: p_encoded => FND_API.G_FALSE );
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO Update_Plan_Text;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get
405: (p_count => x_msg_count ,

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

399: p_data => x_msg_data ,
400: p_encoded => FND_API.G_FALSE );
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO Update_Plan_Text;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get
405: (p_count => x_msg_count ,
406: p_data => x_msg_data ,
407: p_encoded => FND_API.G_FALSE );

Line 407: p_encoded => FND_API.G_FALSE );

403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: FND_MSG_PUB.Count_And_Get
405: (p_count => x_msg_count ,
406: p_data => x_msg_data ,
407: p_encoded => FND_API.G_FALSE );
408: WHEN OTHERS THEN
409: ROLLBACK TO Update_Plan_Text;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

406: p_data => x_msg_data ,
407: p_encoded => FND_API.G_FALSE );
408: WHEN OTHERS THEN
409: ROLLBACK TO Update_Plan_Text;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level
412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg

Line 421: p_encoded => FND_API.G_FALSE );

417: END IF;
418: FND_MSG_PUB.Count_And_Get
419: (p_count => x_msg_count ,
420: p_data => x_msg_data ,
421: p_encoded => FND_API.G_FALSE );
422: END Update_Plan_Text;
423:
424:
425:

Line 435: -- Default = FND_API.G_FALSE

431: -- Pre-reqs : None.
432: -- Parameters :
433: -- IN : p_api_version IN NUMBER Required
434: -- p_init_msg_list IN VARCHAR2 Optional
435: -- Default = FND_API.G_FALSE
436: -- p_commit IN VARCHAR2 Optional
437: -- Default = FND_API.G_FALSE
438: -- p_validation_level IN NUMBER Optional
439: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 437: -- Default = FND_API.G_FALSE

433: -- IN : p_api_version IN NUMBER Required
434: -- p_init_msg_list IN VARCHAR2 Optional
435: -- Default = FND_API.G_FALSE
436: -- p_commit IN VARCHAR2 Optional
437: -- Default = FND_API.G_FALSE
438: -- p_validation_level IN NUMBER Optional
439: -- Default = FND_API.G_VALID_LEVEL_FULL
440: -- p_plan_text IN plan_text_rec_type
441: -- OUT : x_return_status OUT VARCHAR2(1)

Line 439: -- Default = FND_API.G_VALID_LEVEL_FULL

435: -- Default = FND_API.G_FALSE
436: -- p_commit IN VARCHAR2 Optional
437: -- Default = FND_API.G_FALSE
438: -- p_validation_level IN NUMBER Optional
439: -- Default = FND_API.G_VALID_LEVEL_FULL
440: -- p_plan_text IN plan_text_rec_type
441: -- OUT : x_return_status OUT VARCHAR2(1)
442: -- x_msg_count OUT NUMBER
443: -- x_msg_data OUT VARCHAR2(2000)

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

446: --
447: -- End of comments
448: PROCEDURE Delete_Plan_Text (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: p_plan_text IN plan_text_rec_type,
454: x_return_status OUT NOCOPY VARCHAR2,

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

447: -- End of comments
448: PROCEDURE Delete_Plan_Text (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: p_plan_text IN plan_text_rec_type,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,

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

448: PROCEDURE Delete_Plan_Text (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: p_commit IN VARCHAR2 := FND_API.G_FALSE,
452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453: p_plan_text IN plan_text_rec_type,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2

Line 466: IF NOT FND_API.Compatible_API_Call

462: BEGIN
463: -- Standard Start of API savepoint
464: SAVEPOINT Delete_Plan_Text;
465: -- Standard call to check for call compatibility.
466: IF NOT FND_API.Compatible_API_Call
467: (l_api_version ,
468: p_api_version ,
469: l_api_name ,
470: G_PKG_NAME )

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

468: p_api_version ,
469: l_api_name ,
470: G_PKG_NAME )
471: THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;

Line 475: IF FND_API.to_Boolean( p_init_msg_list ) THEN

471: THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478: -- Initialize API return status to success
479: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 479: x_return_status := FND_API.G_RET_STS_SUCCESS;

475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478: -- Initialize API return status to success
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480: -- API body
481:
482: CN_PLAN_TEXTS_PKG.Delete_Row(p_plan_text.plan_text_id);
483:

Line 486: IF FND_API.To_Boolean( p_commit ) THEN

482: CN_PLAN_TEXTS_PKG.Delete_Row(p_plan_text.plan_text_id);
483:
484: -- End of API body.
485: -- Standard check of p_commit.
486: IF FND_API.To_Boolean( p_commit ) THEN
487: COMMIT WORK;
488: END IF;
489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get

Line 493: p_encoded => FND_API.G_FALSE );

489: -- Standard call to get message count and if count is 1, get message info.
490: FND_MSG_PUB.Count_And_Get
491: (p_count => x_msg_count ,
492: p_data => x_msg_data ,
493: p_encoded => FND_API.G_FALSE );
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO Delete_Plan_Text;
497: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 495: WHEN FND_API.G_EXC_ERROR THEN

491: (p_count => x_msg_count ,
492: p_data => x_msg_data ,
493: p_encoded => FND_API.G_FALSE );
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO Delete_Plan_Text;
497: x_return_status := FND_API.G_RET_STS_ERROR ;
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count ,

Line 497: x_return_status := FND_API.G_RET_STS_ERROR ;

493: p_encoded => FND_API.G_FALSE );
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO Delete_Plan_Text;
497: x_return_status := FND_API.G_RET_STS_ERROR ;
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count ,
500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );

Line 501: p_encoded => FND_API.G_FALSE );

497: x_return_status := FND_API.G_RET_STS_ERROR ;
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count ,
500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: ROLLBACK TO Delete_Plan_Text;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get

Line 502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count ,
500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: ROLLBACK TO Delete_Plan_Text;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get
506: (p_count => x_msg_count ,

Line 504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

500: p_data => x_msg_data ,
501: p_encoded => FND_API.G_FALSE );
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: ROLLBACK TO Delete_Plan_Text;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get
506: (p_count => x_msg_count ,
507: p_data => x_msg_data ,
508: p_encoded => FND_API.G_FALSE );

Line 508: p_encoded => FND_API.G_FALSE );

504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: FND_MSG_PUB.Count_And_Get
506: (p_count => x_msg_count ,
507: p_data => x_msg_data ,
508: p_encoded => FND_API.G_FALSE );
509: WHEN OTHERS THEN
510: ROLLBACK TO Delete_Plan_Text;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512: IF FND_MSG_PUB.Check_Msg_Level

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

507: p_data => x_msg_data ,
508: p_encoded => FND_API.G_FALSE );
509: WHEN OTHERS THEN
510: ROLLBACK TO Delete_Plan_Text;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512: IF FND_MSG_PUB.Check_Msg_Level
513: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg

Line 522: p_encoded => FND_API.G_FALSE );

518: END IF;
519: FND_MSG_PUB.Count_And_Get
520: (p_count => x_msg_count ,
521: p_data => x_msg_data ,
522: p_encoded => FND_API.G_FALSE );
523: END Delete_Plan_Text;
524:
525:
526:

Line 535: -- Default = FND_API.G_FALSE

531: -- Pre-reqs : None.
532: -- Parameters :
533: -- IN : p_api_version IN NUMBER Required
534: -- p_init_msg_list IN VARCHAR2 Optional
535: -- Default = FND_API.G_FALSE
536: -- p_commit IN VARCHAR2 Optional
537: -- Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional
539: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 537: -- Default = FND_API.G_FALSE

533: -- IN : p_api_version IN NUMBER Required
534: -- p_init_msg_list IN VARCHAR2 Optional
535: -- Default = FND_API.G_FALSE
536: -- p_commit IN VARCHAR2 Optional
537: -- Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional
539: -- Default = FND_API.G_VALID_LEVEL_FULL
540: -- p_role_id IN NUMBER
541: -- p_role_model_id IN NUMBER

Line 539: -- Default = FND_API.G_VALID_LEVEL_FULL

535: -- Default = FND_API.G_FALSE
536: -- p_commit IN VARCHAR2 Optional
537: -- Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional
539: -- Default = FND_API.G_VALID_LEVEL_FULL
540: -- p_role_id IN NUMBER
541: -- p_role_model_id IN NUMBER
542: -- OUT : x_return_status OUT VARCHAR2(1)
543: -- x_msg_count OUT NUMBER

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

549: --
550: -- End of comments
551: PROCEDURE Get_Plan_Texts (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556: p_role_id IN NUMBER,
557: p_role_model_id IN NUMBER,

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

550: -- End of comments
551: PROCEDURE Get_Plan_Texts (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556: p_role_id IN NUMBER,
557: p_role_model_id IN NUMBER,
558: x_plan_texts OUT NOCOPY plan_text_tbl_type,

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

551: PROCEDURE Get_Plan_Texts (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556: p_role_id IN NUMBER,
557: p_role_model_id IN NUMBER,
558: x_plan_texts OUT NOCOPY plan_text_tbl_type,
559: x_updatable OUT NOCOPY VARCHAR2,

Line 607: IF NOT FND_API.Compatible_API_Call

603: BEGIN
604: -- Standard Start of API savepoint
605: SAVEPOINT Get_Plan_Texts;
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call
608: (l_api_version ,
609: p_api_version ,
610: l_api_name ,
611: G_PKG_NAME )

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

609: p_api_version ,
610: l_api_name ,
611: G_PKG_NAME )
612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;

Line 616: IF FND_API.to_Boolean( p_init_msg_list ) THEN

612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619: -- Initialize API return status to success
620: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 620: x_return_status := FND_API.G_RET_STS_SUCCESS;

616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619: -- Initialize API return status to success
620: x_return_status := FND_API.G_RET_STS_SUCCESS;
621: -- API body
622:
623: BEGIN
624: SELECT contract_title, terms_and_conditions,

Line 709: IF FND_API.To_Boolean( p_commit ) THEN

705: CLOSE l_spt_cr;
706:
707: -- End of API body.
708: -- Standard check of p_commit.
709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get

Line 716: p_encoded => FND_API.G_FALSE );

712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: (p_count => x_msg_count ,
715: p_data => x_msg_data ,
716: p_encoded => FND_API.G_FALSE );
717: EXCEPTION
718: WHEN FND_API.G_EXC_ERROR THEN
719: ROLLBACK TO Get_Plan_Texts;
720: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 718: WHEN FND_API.G_EXC_ERROR THEN

714: (p_count => x_msg_count ,
715: p_data => x_msg_data ,
716: p_encoded => FND_API.G_FALSE );
717: EXCEPTION
718: WHEN FND_API.G_EXC_ERROR THEN
719: ROLLBACK TO Get_Plan_Texts;
720: x_return_status := FND_API.G_RET_STS_ERROR ;
721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count ,

Line 720: x_return_status := FND_API.G_RET_STS_ERROR ;

716: p_encoded => FND_API.G_FALSE );
717: EXCEPTION
718: WHEN FND_API.G_EXC_ERROR THEN
719: ROLLBACK TO Get_Plan_Texts;
720: x_return_status := FND_API.G_RET_STS_ERROR ;
721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count ,
723: p_data => x_msg_data ,
724: p_encoded => FND_API.G_FALSE );

Line 724: p_encoded => FND_API.G_FALSE );

720: x_return_status := FND_API.G_RET_STS_ERROR ;
721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count ,
723: p_data => x_msg_data ,
724: p_encoded => FND_API.G_FALSE );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Get_Plan_Texts;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728: FND_MSG_PUB.Count_And_Get

Line 725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

721: FND_MSG_PUB.Count_And_Get
722: (p_count => x_msg_count ,
723: p_data => x_msg_data ,
724: p_encoded => FND_API.G_FALSE );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Get_Plan_Texts;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728: FND_MSG_PUB.Count_And_Get
729: (p_count => x_msg_count ,

Line 727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

723: p_data => x_msg_data ,
724: p_encoded => FND_API.G_FALSE );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Get_Plan_Texts;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728: FND_MSG_PUB.Count_And_Get
729: (p_count => x_msg_count ,
730: p_data => x_msg_data ,
731: p_encoded => FND_API.G_FALSE );

Line 731: p_encoded => FND_API.G_FALSE );

727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
728: FND_MSG_PUB.Count_And_Get
729: (p_count => x_msg_count ,
730: p_data => x_msg_data ,
731: p_encoded => FND_API.G_FALSE );
732: WHEN OTHERS THEN
733: ROLLBACK TO Get_Plan_Texts;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF FND_MSG_PUB.Check_Msg_Level

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

730: p_data => x_msg_data ,
731: p_encoded => FND_API.G_FALSE );
732: WHEN OTHERS THEN
733: ROLLBACK TO Get_Plan_Texts;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: IF FND_MSG_PUB.Check_Msg_Level
736: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.Add_Exc_Msg

Line 745: p_encoded => FND_API.G_FALSE );

741: END IF;
742: FND_MSG_PUB.Count_And_Get
743: (p_count => x_msg_count ,
744: p_data => x_msg_data ,
745: p_encoded => FND_API.G_FALSE );
746: END Get_Plan_Texts;
747:
748:
749: -- Start of comments

Line 757: -- Default = FND_API.G_FALSE

753: -- Pre-reqs : None.
754: -- Parameters :
755: -- IN : p_api_version IN NUMBER Required
756: -- p_init_msg_list IN VARCHAR2 Optional
757: -- Default = FND_API.G_FALSE
758: -- p_commit IN VARCHAR2 Optional
759: -- Default = FND_API.G_FALSE
760: -- p_validation_level IN NUMBER Optional
761: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 759: -- Default = FND_API.G_FALSE

755: -- IN : p_api_version IN NUMBER Required
756: -- p_init_msg_list IN VARCHAR2 Optional
757: -- Default = FND_API.G_FALSE
758: -- p_commit IN VARCHAR2 Optional
759: -- Default = FND_API.G_FALSE
760: -- p_validation_level IN NUMBER Optional
761: -- Default = FND_API.G_VALID_LEVEL_FULL
762: -- p_role_id IN NUMBER
763: -- p_role_model_id IN NUMBER

Line 761: -- Default = FND_API.G_VALID_LEVEL_FULL

757: -- Default = FND_API.G_FALSE
758: -- p_commit IN VARCHAR2 Optional
759: -- Default = FND_API.G_FALSE
760: -- p_validation_level IN NUMBER Optional
761: -- Default = FND_API.G_VALID_LEVEL_FULL
762: -- p_role_id IN NUMBER
763: -- p_role_model_id IN NUMBER
764: -- OUT : x_return_status OUT VARCHAR2(1)
765: -- x_msg_count OUT NUMBER

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

770: --
771: -- End of comments
772: PROCEDURE Get_Fixed_Quota_Cates (
773: p_api_version IN NUMBER,
774: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
775: p_commit IN VARCHAR2 := FND_API.G_FALSE,
776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
777: p_role_id IN NUMBER,
778: p_role_model_id IN NUMBER,

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

771: -- End of comments
772: PROCEDURE Get_Fixed_Quota_Cates (
773: p_api_version IN NUMBER,
774: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
775: p_commit IN VARCHAR2 := FND_API.G_FALSE,
776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
777: p_role_id IN NUMBER,
778: p_role_model_id IN NUMBER,
779: x_quota_cates OUT NOCOPY quota_cate_tbl_type,

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

772: PROCEDURE Get_Fixed_Quota_Cates (
773: p_api_version IN NUMBER,
774: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
775: p_commit IN VARCHAR2 := FND_API.G_FALSE,
776: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
777: p_role_id IN NUMBER,
778: p_role_model_id IN NUMBER,
779: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
780: x_return_status OUT NOCOPY VARCHAR2,

Line 808: IF NOT FND_API.Compatible_API_Call

804: BEGIN
805: -- Standard Start of API savepoint
806: SAVEPOINT Get_Fixed_Quota_Cates;
807: -- Standard call to check for call compatibility.
808: IF NOT FND_API.Compatible_API_Call
809: (l_api_version ,
810: p_api_version ,
811: l_api_name ,
812: G_PKG_NAME )

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

810: p_api_version ,
811: l_api_name ,
812: G_PKG_NAME )
813: THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816: -- Initialize message list if p_init_msg_list is set to TRUE.
817: IF FND_API.to_Boolean( p_init_msg_list ) THEN
818: FND_MSG_PUB.initialize;

Line 817: IF FND_API.to_Boolean( p_init_msg_list ) THEN

813: THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816: -- Initialize message list if p_init_msg_list is set to TRUE.
817: IF FND_API.to_Boolean( p_init_msg_list ) THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: -- Initialize API return status to success
821: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 821: x_return_status := FND_API.G_RET_STS_SUCCESS;

817: IF FND_API.to_Boolean( p_init_msg_list ) THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: -- Initialize API return status to success
821: x_return_status := FND_API.G_RET_STS_SUCCESS;
822: -- API body
823:
824: l_ctr := 1;
825:

Line 845: IF FND_API.To_Boolean( p_commit ) THEN

841: CLOSE l_qcs_cr;
842:
843: -- End of API body.
844: -- Standard check of p_commit.
845: IF FND_API.To_Boolean( p_commit ) THEN
846: COMMIT WORK;
847: END IF;
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get

Line 852: p_encoded => FND_API.G_FALSE );

848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get
850: (p_count => x_msg_count ,
851: p_data => x_msg_data ,
852: p_encoded => FND_API.G_FALSE );
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: ROLLBACK TO Get_Fixed_Quota_Cates;
856: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 854: WHEN FND_API.G_EXC_ERROR THEN

850: (p_count => x_msg_count ,
851: p_data => x_msg_data ,
852: p_encoded => FND_API.G_FALSE );
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: ROLLBACK TO Get_Fixed_Quota_Cates;
856: x_return_status := FND_API.G_RET_STS_ERROR ;
857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count ,

Line 856: x_return_status := FND_API.G_RET_STS_ERROR ;

852: p_encoded => FND_API.G_FALSE );
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: ROLLBACK TO Get_Fixed_Quota_Cates;
856: x_return_status := FND_API.G_RET_STS_ERROR ;
857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count ,
859: p_data => x_msg_data ,
860: p_encoded => FND_API.G_FALSE );

Line 860: p_encoded => FND_API.G_FALSE );

856: x_return_status := FND_API.G_RET_STS_ERROR ;
857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count ,
859: p_data => x_msg_data ,
860: p_encoded => FND_API.G_FALSE );
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO Get_Fixed_Quota_Cates;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get

Line 861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count ,
859: p_data => x_msg_data ,
860: p_encoded => FND_API.G_FALSE );
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO Get_Fixed_Quota_Cates;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get
865: (p_count => x_msg_count ,

Line 863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

859: p_data => x_msg_data ,
860: p_encoded => FND_API.G_FALSE );
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO Get_Fixed_Quota_Cates;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get
865: (p_count => x_msg_count ,
866: p_data => x_msg_data ,
867: p_encoded => FND_API.G_FALSE );

Line 867: p_encoded => FND_API.G_FALSE );

863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get
865: (p_count => x_msg_count ,
866: p_data => x_msg_data ,
867: p_encoded => FND_API.G_FALSE );
868: WHEN OTHERS THEN
869: ROLLBACK TO Get_Fixed_Quota_Cates;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: IF FND_MSG_PUB.Check_Msg_Level

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

866: p_data => x_msg_data ,
867: p_encoded => FND_API.G_FALSE );
868: WHEN OTHERS THEN
869: ROLLBACK TO Get_Fixed_Quota_Cates;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
871: IF FND_MSG_PUB.Check_Msg_Level
872: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: FND_MSG_PUB.Add_Exc_Msg

Line 881: p_encoded => FND_API.G_FALSE );

877: END IF;
878: FND_MSG_PUB.Count_And_Get
879: (p_count => x_msg_count ,
880: p_data => x_msg_data ,
881: p_encoded => FND_API.G_FALSE );
882: END Get_Fixed_Quota_Cates;
883:
884: -- Start of comments
885: -- API name : Get_Var_Quota_Cates

Line 892: -- Default = FND_API.G_FALSE

888: -- Pre-reqs : None.
889: -- Parameters :
890: -- IN : p_api_version IN NUMBER Required
891: -- p_init_msg_list IN VARCHAR2 Optional
892: -- Default = FND_API.G_FALSE
893: -- p_commit IN VARCHAR2 Optional
894: -- Default = FND_API.G_FALSE
895: -- p_validation_level IN NUMBER Optional
896: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 894: -- Default = FND_API.G_FALSE

890: -- IN : p_api_version IN NUMBER Required
891: -- p_init_msg_list IN VARCHAR2 Optional
892: -- Default = FND_API.G_FALSE
893: -- p_commit IN VARCHAR2 Optional
894: -- Default = FND_API.G_FALSE
895: -- p_validation_level IN NUMBER Optional
896: -- Default = FND_API.G_VALID_LEVEL_FULL
897: -- p_role_id IN NUMBER
898: -- p_role_model_id IN NUMBER

Line 896: -- Default = FND_API.G_VALID_LEVEL_FULL

892: -- Default = FND_API.G_FALSE
893: -- p_commit IN VARCHAR2 Optional
894: -- Default = FND_API.G_FALSE
895: -- p_validation_level IN NUMBER Optional
896: -- Default = FND_API.G_VALID_LEVEL_FULL
897: -- p_role_id IN NUMBER
898: -- p_role_model_id IN NUMBER
899: -- OUT : x_return_status OUT VARCHAR2(1)
900: -- x_msg_count OUT NUMBER

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

905: --
906: -- End of comments
907: PROCEDURE Get_Var_Quota_Cates (
908: p_api_version IN NUMBER,
909: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
910: p_commit IN VARCHAR2 := FND_API.G_FALSE,
911: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
912: p_role_id IN NUMBER,
913: p_role_model_id IN NUMBER,

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

906: -- End of comments
907: PROCEDURE Get_Var_Quota_Cates (
908: p_api_version IN NUMBER,
909: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
910: p_commit IN VARCHAR2 := FND_API.G_FALSE,
911: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
912: p_role_id IN NUMBER,
913: p_role_model_id IN NUMBER,
914: x_quota_cates OUT NOCOPY quota_cate_tbl_type,

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

907: PROCEDURE Get_Var_Quota_Cates (
908: p_api_version IN NUMBER,
909: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
910: p_commit IN VARCHAR2 := FND_API.G_FALSE,
911: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
912: p_role_id IN NUMBER,
913: p_role_model_id IN NUMBER,
914: x_quota_cates OUT NOCOPY quota_cate_tbl_type,
915: x_return_status OUT NOCOPY VARCHAR2,

Line 944: IF NOT FND_API.Compatible_API_Call

940: BEGIN
941: -- Standard Start of API savepoint
942: SAVEPOINT Get_Var_Quota_Cates;
943: -- Standard call to check for call compatibility.
944: IF NOT FND_API.Compatible_API_Call
945: (l_api_version ,
946: p_api_version ,
947: l_api_name ,
948: G_PKG_NAME )

Line 950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

946: p_api_version ,
947: l_api_name ,
948: G_PKG_NAME )
949: THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952: -- Initialize message list if p_init_msg_list is set to TRUE.
953: IF FND_API.to_Boolean( p_init_msg_list ) THEN
954: FND_MSG_PUB.initialize;

Line 953: IF FND_API.to_Boolean( p_init_msg_list ) THEN

949: THEN
950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
951: END IF;
952: -- Initialize message list if p_init_msg_list is set to TRUE.
953: IF FND_API.to_Boolean( p_init_msg_list ) THEN
954: FND_MSG_PUB.initialize;
955: END IF;
956: -- Initialize API return status to success
957: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 957: x_return_status := FND_API.G_RET_STS_SUCCESS;

953: IF FND_API.to_Boolean( p_init_msg_list ) THEN
954: FND_MSG_PUB.initialize;
955: END IF;
956: -- Initialize API return status to success
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958: -- API body
959:
960: l_ctr := 1;
961:

Line 990: IF FND_API.To_Boolean( p_commit ) THEN

986: CLOSE l_qcs_cr;
987:
988: -- End of API body.
989: -- Standard check of p_commit.
990: IF FND_API.To_Boolean( p_commit ) THEN
991: COMMIT WORK;
992: END IF;
993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get

Line 997: p_encoded => FND_API.G_FALSE );

993: -- Standard call to get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get
995: (p_count => x_msg_count ,
996: p_data => x_msg_data ,
997: p_encoded => FND_API.G_FALSE );
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Get_Var_Quota_Cates;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995: (p_count => x_msg_count ,
996: p_data => x_msg_data ,
997: p_encoded => FND_API.G_FALSE );
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Get_Var_Quota_Cates;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR ;

997: p_encoded => FND_API.G_FALSE );
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Get_Var_Quota_Cates;
1001: x_return_status := FND_API.G_RET_STS_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,
1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE );

Line 1005: p_encoded => FND_API.G_FALSE );

1001: x_return_status := FND_API.G_RET_STS_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,
1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE );
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007: ROLLBACK TO Get_Var_Quota_Cates;
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: FND_MSG_PUB.Count_And_Get

Line 1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,
1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE );
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007: ROLLBACK TO Get_Var_Quota_Cates;
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010: (p_count => x_msg_count ,

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE );
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007: ROLLBACK TO Get_Var_Quota_Cates;
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010: (p_count => x_msg_count ,
1011: p_data => x_msg_data ,
1012: p_encoded => FND_API.G_FALSE );

Line 1012: p_encoded => FND_API.G_FALSE );

1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: FND_MSG_PUB.Count_And_Get
1010: (p_count => x_msg_count ,
1011: p_data => x_msg_data ,
1012: p_encoded => FND_API.G_FALSE );
1013: WHEN OTHERS THEN
1014: ROLLBACK TO Get_Var_Quota_Cates;
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016: IF FND_MSG_PUB.Check_Msg_Level

Line 1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1011: p_data => x_msg_data ,
1012: p_encoded => FND_API.G_FALSE );
1013: WHEN OTHERS THEN
1014: ROLLBACK TO Get_Var_Quota_Cates;
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016: IF FND_MSG_PUB.Check_Msg_Level
1017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: FND_MSG_PUB.Add_Exc_Msg

Line 1026: p_encoded => FND_API.G_FALSE );

1022: END IF;
1023: FND_MSG_PUB.Count_And_Get
1024: (p_count => x_msg_count ,
1025: p_data => x_msg_data ,
1026: p_encoded => FND_API.G_FALSE );
1027: END Get_Var_Quota_Cates;
1028:
1029:
1030: -- Start of comments

Line 1038: -- Default = FND_API.G_FALSE

1034: -- Pre-reqs : None.
1035: -- Parameters :
1036: -- IN : p_api_version IN NUMBER Required
1037: -- p_init_msg_list IN VARCHAR2 Optional
1038: -- Default = FND_API.G_FALSE
1039: -- p_commit IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_validation_level IN NUMBER Optional
1042: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1040: -- Default = FND_API.G_FALSE

1036: -- IN : p_api_version IN NUMBER Required
1037: -- p_init_msg_list IN VARCHAR2 Optional
1038: -- Default = FND_API.G_FALSE
1039: -- p_commit IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_validation_level IN NUMBER Optional
1042: -- Default = FND_API.G_VALID_LEVEL_FULL
1043: -- p_role_id IN NUMBER
1044: -- p_role_model_id IN NUMBER

Line 1042: -- Default = FND_API.G_VALID_LEVEL_FULL

1038: -- Default = FND_API.G_FALSE
1039: -- p_commit IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_validation_level IN NUMBER Optional
1042: -- Default = FND_API.G_VALID_LEVEL_FULL
1043: -- p_role_id IN NUMBER
1044: -- p_role_model_id IN NUMBER
1045: -- OUT : x_return_status OUT VARCHAR2(1)
1046: -- x_msg_count OUT NUMBER

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

1051: --
1052: -- End of comments
1053: PROCEDURE Get_Quota_Cates (
1054: p_api_version IN NUMBER,
1055: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1056: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1057: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1058: p_role_id IN NUMBER,
1059: p_role_model_id IN NUMBER,

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

1052: -- End of comments
1053: PROCEDURE Get_Quota_Cates (
1054: p_api_version IN NUMBER,
1055: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1056: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1057: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1058: p_role_id IN NUMBER,
1059: p_role_model_id IN NUMBER,
1060: p_quota_cate_type IN VARCHAR2,

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

1053: PROCEDURE Get_Quota_Cates (
1054: p_api_version IN NUMBER,
1055: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1056: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1057: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1058: p_role_id IN NUMBER,
1059: p_role_model_id IN NUMBER,
1060: p_quota_cate_type IN VARCHAR2,
1061: x_quota_cates OUT NOCOPY quota_cate_tbl_type,

Line 1093: IF NOT FND_API.Compatible_API_Call

1089: BEGIN
1090: -- Standard Start of API savepoint
1091: SAVEPOINT Get_Quota_Cates;
1092: -- Standard call to check for call compatibility.
1093: IF NOT FND_API.Compatible_API_Call
1094: (l_api_version ,
1095: p_api_version ,
1096: l_api_name ,
1097: G_PKG_NAME )

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1095: p_api_version ,
1096: l_api_name ,
1097: G_PKG_NAME )
1098: THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101: -- Initialize message list if p_init_msg_list is set to TRUE.
1102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1103: FND_MSG_PUB.initialize;

Line 1102: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1098: THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101: -- Initialize message list if p_init_msg_list is set to TRUE.
1102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105: -- Initialize API return status to success
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

1102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105: -- Initialize API return status to success
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107: -- API body
1108:
1109: l_ctr := 1;
1110:

Line 1141: IF FND_API.To_Boolean( p_commit ) THEN

1137: CLOSE l_qcs_cr;
1138:
1139: -- End of API body.
1140: -- Standard check of p_commit.
1141: IF FND_API.To_Boolean( p_commit ) THEN
1142: COMMIT WORK;
1143: END IF;
1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get

Line 1148: p_encoded => FND_API.G_FALSE );

1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get
1146: (p_count => x_msg_count ,
1147: p_data => x_msg_data ,
1148: p_encoded => FND_API.G_FALSE );
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO Get_Quota_Cates;
1152: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1150: WHEN FND_API.G_EXC_ERROR THEN

1146: (p_count => x_msg_count ,
1147: p_data => x_msg_data ,
1148: p_encoded => FND_API.G_FALSE );
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO Get_Quota_Cates;
1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: FND_MSG_PUB.Count_And_Get
1154: (p_count => x_msg_count ,

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR ;

1148: p_encoded => FND_API.G_FALSE );
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO Get_Quota_Cates;
1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: FND_MSG_PUB.Count_And_Get
1154: (p_count => x_msg_count ,
1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );

Line 1156: p_encoded => FND_API.G_FALSE );

1152: x_return_status := FND_API.G_RET_STS_ERROR ;
1153: FND_MSG_PUB.Count_And_Get
1154: (p_count => x_msg_count ,
1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Get_Quota_Cates;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.Count_And_Get

Line 1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1153: FND_MSG_PUB.Count_And_Get
1154: (p_count => x_msg_count ,
1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Get_Quota_Cates;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count ,

Line 1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Get_Quota_Cates;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count ,
1162: p_data => x_msg_data ,
1163: p_encoded => FND_API.G_FALSE );

Line 1163: p_encoded => FND_API.G_FALSE );

1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count ,
1162: p_data => x_msg_data ,
1163: p_encoded => FND_API.G_FALSE );
1164: WHEN OTHERS THEN
1165: ROLLBACK TO Get_Quota_Cates;
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167: IF FND_MSG_PUB.Check_Msg_Level

Line 1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1162: p_data => x_msg_data ,
1163: p_encoded => FND_API.G_FALSE );
1164: WHEN OTHERS THEN
1165: ROLLBACK TO Get_Quota_Cates;
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167: IF FND_MSG_PUB.Check_Msg_Level
1168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1169: THEN
1170: FND_MSG_PUB.Add_Exc_Msg

Line 1177: p_encoded => FND_API.G_FALSE );

1173: END IF;
1174: FND_MSG_PUB.Count_And_Get
1175: (p_count => x_msg_count ,
1176: p_data => x_msg_data ,
1177: p_encoded => FND_API.G_FALSE );
1178: END Get_Quota_Cates;
1179:
1180:
1181: -- Start of comments

Line 1189: -- Default = FND_API.G_FALSE

1185: -- Pre-reqs : None.
1186: -- Parameters :
1187: -- IN : p_api_version IN NUMBER Required
1188: -- p_init_msg_list IN VARCHAR2 Optional
1189: -- Default = FND_API.G_FALSE
1190: -- p_commit IN VARCHAR2 Optional
1191: -- Default = FND_API.G_FALSE
1192: -- p_validation_level IN NUMBER Optional
1193: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1191: -- Default = FND_API.G_FALSE

1187: -- IN : p_api_version IN NUMBER Required
1188: -- p_init_msg_list IN VARCHAR2 Optional
1189: -- Default = FND_API.G_FALSE
1190: -- p_commit IN VARCHAR2 Optional
1191: -- Default = FND_API.G_FALSE
1192: -- p_validation_level IN NUMBER Optional
1193: -- Default = FND_API.G_VALID_LEVEL_FULL
1194: -- p_role_id IN NUMBER
1195: -- p_role_model_id IN NUMBER

Line 1193: -- Default = FND_API.G_VALID_LEVEL_FULL

1189: -- Default = FND_API.G_FALSE
1190: -- p_commit IN VARCHAR2 Optional
1191: -- Default = FND_API.G_FALSE
1192: -- p_validation_level IN NUMBER Optional
1193: -- Default = FND_API.G_VALID_LEVEL_FULL
1194: -- p_role_id IN NUMBER
1195: -- p_role_model_id IN NUMBER
1196: -- OUT : x_return_status OUT VARCHAR2(1)
1197: -- x_msg_count OUT NUMBER

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

1202: --
1203: -- End of comments
1204: PROCEDURE Get_Role_Name (
1205: p_api_version IN NUMBER,
1206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1209: p_role_id IN NUMBER,
1210: p_role_model_id IN NUMBER,

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

1203: -- End of comments
1204: PROCEDURE Get_Role_Name (
1205: p_api_version IN NUMBER,
1206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1209: p_role_id IN NUMBER,
1210: p_role_model_id IN NUMBER,
1211: x_role_name OUT NOCOPY VARCHAR2,

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

1204: PROCEDURE Get_Role_Name (
1205: p_api_version IN NUMBER,
1206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1209: p_role_id IN NUMBER,
1210: p_role_model_id IN NUMBER,
1211: x_role_name OUT NOCOPY VARCHAR2,
1212: x_return_status OUT NOCOPY VARCHAR2,

Line 1224: IF NOT FND_API.Compatible_API_Call

1220: BEGIN
1221: -- Standard Start of API savepoint
1222: SAVEPOINT Get_Role_Name;
1223: -- Standard call to check for call compatibility.
1224: IF NOT FND_API.Compatible_API_Call
1225: (l_api_version ,
1226: p_api_version ,
1227: l_api_name ,
1228: G_PKG_NAME )

Line 1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1226: p_api_version ,
1227: l_api_name ,
1228: G_PKG_NAME )
1229: THEN
1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END IF;
1232: -- Initialize message list if p_init_msg_list is set to TRUE.
1233: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1234: FND_MSG_PUB.initialize;

Line 1233: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1229: THEN
1230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1231: END IF;
1232: -- Initialize message list if p_init_msg_list is set to TRUE.
1233: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1234: FND_MSG_PUB.initialize;
1235: END IF;
1236: -- Initialize API return status to success
1237: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1237: x_return_status := FND_API.G_RET_STS_SUCCESS;

1233: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1234: FND_MSG_PUB.initialize;
1235: END IF;
1236: -- Initialize API return status to success
1237: x_return_status := FND_API.G_RET_STS_SUCCESS;
1238: -- API body
1239:
1240: IF p_role_model_id is NULL THEN
1241: SELECT name INTO x_role_name

Line 1252: IF FND_API.To_Boolean( p_commit ) THEN

1248: END IF;
1249:
1250: -- End of API body.
1251: -- Standard check of p_commit.
1252: IF FND_API.To_Boolean( p_commit ) THEN
1253: COMMIT WORK;
1254: END IF;
1255: -- Standard call to get message count and if count is 1, get message info.
1256: FND_MSG_PUB.Count_And_Get

Line 1259: p_encoded => FND_API.G_FALSE );

1255: -- Standard call to get message count and if count is 1, get message info.
1256: FND_MSG_PUB.Count_And_Get
1257: (p_count => x_msg_count ,
1258: p_data => x_msg_data ,
1259: p_encoded => FND_API.G_FALSE );
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO Get_Role_Name;
1263: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1261: WHEN FND_API.G_EXC_ERROR THEN

1257: (p_count => x_msg_count ,
1258: p_data => x_msg_data ,
1259: p_encoded => FND_API.G_FALSE );
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO Get_Role_Name;
1263: x_return_status := FND_API.G_RET_STS_ERROR ;
1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count ,

Line 1263: x_return_status := FND_API.G_RET_STS_ERROR ;

1259: p_encoded => FND_API.G_FALSE );
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO Get_Role_Name;
1263: x_return_status := FND_API.G_RET_STS_ERROR ;
1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count ,
1266: p_data => x_msg_data ,
1267: p_encoded => FND_API.G_FALSE );

Line 1267: p_encoded => FND_API.G_FALSE );

1263: x_return_status := FND_API.G_RET_STS_ERROR ;
1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count ,
1266: p_data => x_msg_data ,
1267: p_encoded => FND_API.G_FALSE );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO Get_Role_Name;
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: FND_MSG_PUB.Count_And_Get

Line 1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1264: FND_MSG_PUB.Count_And_Get
1265: (p_count => x_msg_count ,
1266: p_data => x_msg_data ,
1267: p_encoded => FND_API.G_FALSE );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO Get_Role_Name;
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: FND_MSG_PUB.Count_And_Get
1272: (p_count => x_msg_count ,

Line 1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1266: p_data => x_msg_data ,
1267: p_encoded => FND_API.G_FALSE );
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO Get_Role_Name;
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: FND_MSG_PUB.Count_And_Get
1272: (p_count => x_msg_count ,
1273: p_data => x_msg_data ,
1274: p_encoded => FND_API.G_FALSE );

Line 1274: p_encoded => FND_API.G_FALSE );

1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1271: FND_MSG_PUB.Count_And_Get
1272: (p_count => x_msg_count ,
1273: p_data => x_msg_data ,
1274: p_encoded => FND_API.G_FALSE );
1275: WHEN OTHERS THEN
1276: ROLLBACK TO Get_Role_Name;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: IF FND_MSG_PUB.Check_Msg_Level

Line 1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1273: p_data => x_msg_data ,
1274: p_encoded => FND_API.G_FALSE );
1275: WHEN OTHERS THEN
1276: ROLLBACK TO Get_Role_Name;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: IF FND_MSG_PUB.Check_Msg_Level
1279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: FND_MSG_PUB.Add_Exc_Msg

Line 1288: p_encoded => FND_API.G_FALSE );

1284: END IF;
1285: FND_MSG_PUB.Count_And_Get
1286: (p_count => x_msg_count ,
1287: p_data => x_msg_data ,
1288: p_encoded => FND_API.G_FALSE );
1289: END Get_Role_Name;
1290:
1291:
1292: