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.JTF_QUALIFIER_PUB dependencies on FND_API

Line 51: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

47: -- p_Qual_Usgs_Rec Qual_Usgs_All_Rec_Type G_MISS_QUAL_USGS_ALL_REC
48: --
49: -- Optional
50: -- Parameter Name Data Type Default
51: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
52: -- P_Commit VARCHAR2 FND_API.G_FALSE
53: --
54: -- OUT :
55: -- Parameter Name Data Type Default

Line 52: -- P_Commit VARCHAR2 FND_API.G_FALSE

48: --
49: -- Optional
50: -- Parameter Name Data Type Default
51: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
52: -- P_Commit VARCHAR2 FND_API.G_FALSE
53: --
54: -- OUT :
55: -- Parameter Name Data Type Default
56: -- x_Return_Status VARCHAR2(1)

Line 74: p_Init_Msg_List IN VARCHAR2 ,-- := FND_API.G_FALSE,

70: --
71: PROCEDURE Create_Qualifier
72: (p_Api_Version IN NUMBER,
73: -- commented out eihsu 11/04
74: p_Init_Msg_List IN VARCHAR2 ,-- := FND_API.G_FALSE,
75: p_Commit IN VARCHAR2 ,-- := FND_API.G_FALSE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_Msg_Count OUT NOCOPY NUMBER,
78: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 75: p_Commit IN VARCHAR2 ,-- := FND_API.G_FALSE,

71: PROCEDURE Create_Qualifier
72: (p_Api_Version IN NUMBER,
73: -- commented out eihsu 11/04
74: p_Init_Msg_List IN VARCHAR2 ,-- := FND_API.G_FALSE,
75: p_Commit IN VARCHAR2 ,-- := FND_API.G_FALSE,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_Msg_Count OUT NOCOPY NUMBER,
78: x_Msg_Data OUT NOCOPY VARCHAR2,
79: -- commented out eihsu 11/04

Line 98: IF NOT FND_API.Compatible_API_Call (

94: -- Standard Start of API savepoint;
95: SAVEPOINT CREATE_QUALIFIER_PUB;
96:
97: -- Standard call to check for call compatibility.
98: IF NOT FND_API.Compatible_API_Call (
99: l_api_version,
100: p_api_version ,
101: l_api_name,
102: G_PKG_NAME)

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: p_api_version ,
101: l_api_name,
102: G_PKG_NAME)
103: THEN
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106:
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF FND_API.to_Boolean( p_init_msg_list )

Line 108: IF FND_API.to_Boolean( p_init_msg_list )

104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106:
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF FND_API.to_Boolean( p_init_msg_list )
109: THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112:

Line 125: l_return_status := FND_API.G_RET_STS_SUCCESS;

121: -- Start of API body.
122: -------------------------------------------------------------------------------------------------------
123:
124: -- Initialize API return status to success
125: l_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: ----plsdbg.put('QUALPUB.CREATE_QUALIFIER: calling PRIVATE.Create_Qualifier ');
128:
129: -- All of the values have been converted, so call the Create_Qualifier Private API

Line 131: p_Init_Msg_List => FND_API.G_FALSE,

127: ----plsdbg.put('QUALPUB.CREATE_QUALIFIER: calling PRIVATE.Create_Qualifier ');
128:
129: -- All of the values have been converted, so call the Create_Qualifier Private API
130: JTF_QUALIFIER_PVT.Create_Qualifier ( p_api_version => 1.0,
131: p_Init_Msg_List => FND_API.G_FALSE,
132: p_Commit => FND_API.G_FALSE,
133: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
134: x_Return_Status => l_return_status,
135: x_Msg_Count => x_msg_count,

Line 132: p_Commit => FND_API.G_FALSE,

128:
129: -- All of the values have been converted, so call the Create_Qualifier Private API
130: JTF_QUALIFIER_PVT.Create_Qualifier ( p_api_version => 1.0,
131: p_Init_Msg_List => FND_API.G_FALSE,
132: p_Commit => FND_API.G_FALSE,
133: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
134: x_Return_Status => l_return_status,
135: x_Msg_Count => x_msg_count,
136: x_Msg_Data => x_msg_data,

Line 133: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

129: -- All of the values have been converted, so call the Create_Qualifier Private API
130: JTF_QUALIFIER_PVT.Create_Qualifier ( p_api_version => 1.0,
131: p_Init_Msg_List => FND_API.G_FALSE,
132: p_Commit => FND_API.G_FALSE,
133: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
134: x_Return_Status => l_return_status,
135: x_Msg_Count => x_msg_count,
136: x_Msg_Data => x_msg_data,
137: p_Seed_Qual_Rec => p_seed_qual_rec,

Line 144: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

140: x_Qual_Usgs_Rec => x_qual_usgs_rec);
141:
142: --dbms_output.put_line('After calling private JTF_QUALIFIER_PVT.Create_Qualifier ');
143:
144: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;

Line 145: RAISE FND_API.G_EXC_ERROR;

141:
142: --dbms_output.put_line('After calling private JTF_QUALIFIER_PVT.Create_Qualifier ');
143:
144: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:

Line 146: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

142: --dbms_output.put_line('After calling private JTF_QUALIFIER_PVT.Create_Qualifier ');
143:
144: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: /* save return status */

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143:
144: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: /* save return status */
151: x_return_status := l_return_status;

Line 158: IF FND_API.To_Boolean ( p_commit )

154: -- End of API body.
155: -------------------------------------------------------------------------------------------------------
156:
157: -- Standard check of p_commit.
158: IF FND_API.To_Boolean ( p_commit )
159: THEN
160: COMMIT WORK;
161: END IF;
162:

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176:
177:
178: EXCEPTION
179:
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO CREATE_QUALIFIER_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR ;
183:
184: FND_MSG_PUB.Count_And_Get

Line 182: x_return_status := FND_API.G_RET_STS_ERROR ;

178: EXCEPTION
179:
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO CREATE_QUALIFIER_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR ;
183:
184: FND_MSG_PUB.Count_And_Get
185: ( p_count => x_msg_count,
186: p_data => x_msg_data

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: ( p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO CREATE_QUALIFIER_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192:
193: FND_MSG_PUB.Count_And_Get

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

187: );
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO CREATE_QUALIFIER_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192:
193: FND_MSG_PUB.Count_And_Get
194: ( p_count => x_msg_count,
195: p_data => x_msg_data

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

197:
198:
199: WHEN OTHERS THEN
200: ROLLBACK TO CREATE_QUALIFIER_PUB;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202:
203: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
205: END IF;

Line 235: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

231: -- p_Qual_Usgs_Rec Qual_Usgs_All_Rec_Type
232: --
233: -- Optional
234: -- Parameter Name Data Type Default
235: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
236: -- P_Commit VARCHAR2 FND_API.G_FALSE
237: --
238: -- OUT :
239: -- Parameter Name Data Type

Line 236: -- P_Commit VARCHAR2 FND_API.G_FALSE

232: --
233: -- Optional
234: -- Parameter Name Data Type Default
235: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
236: -- P_Commit VARCHAR2 FND_API.G_FALSE
237: --
238: -- OUT :
239: -- Parameter Name Data Type
240: -- x_Return_Status VARCHAR2(1)

Line 254: p_Init_Msg_List IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,

250: -- End of Comments
251: --
252: PROCEDURE Update_Qualifier
253: (p_api_version IN NUMBER,
254: p_Init_Msg_List IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
255: p_Commit IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
256: x_Return_Status OUT NOCOPY VARCHAR2,
257: x_Msg_Count OUT NOCOPY NUMBER,
258: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 255: p_Commit IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,

251: --
252: PROCEDURE Update_Qualifier
253: (p_api_version IN NUMBER,
254: p_Init_Msg_List IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
255: p_Commit IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
256: x_Return_Status OUT NOCOPY VARCHAR2,
257: x_Msg_Count OUT NOCOPY NUMBER,
258: x_Msg_Data OUT NOCOPY VARCHAR2,
259: p_Seed_Qual_Rec IN Seed_Qual_Rec_Type,

Line 284: IF NOT FND_API.Compatible_API_Call (

280: -- Standard Start of API savepoint;
281: SAVEPOINT UPDATE_QUALIFIER_PUB;
282:
283: -- Standard call to check for call compatibility.
284: IF NOT FND_API.Compatible_API_Call (
285: l_api_version,
286: p_api_version ,
287: l_api_name,
288: G_PKG_NAME)

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286: p_api_version ,
287: l_api_name,
288: G_PKG_NAME)
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )

Line 294: IF FND_API.to_Boolean( p_init_msg_list )

290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )
295: THEN
296: FND_MSG_PUB.initialize;
297: END IF;
298:

Line 311: l_return_status := FND_API.G_RET_STS_SUCCESS;

307: -- Start of API body.
308: -------------------------------------------------------------------------------------------------------
309:
310: -- Initialize API return status to success
311: l_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: ----plsdbg.put('QUALPUB.UPDATE_QUAL: Calling Update Qual in PVT package');
314:
315: -- All of the values have been converted, so call the Create_Qualifier Private API

Line 317: p_Init_Msg_List => FND_API.G_FALSE,

313: ----plsdbg.put('QUALPUB.UPDATE_QUAL: Calling Update Qual in PVT package');
314:
315: -- All of the values have been converted, so call the Create_Qualifier Private API
316: JTF_QUALIFIER_PVT.Update_Qualifier ( p_api_version => 1.0,
317: p_Init_Msg_List => FND_API.G_FALSE,
318: p_Commit => FND_API.G_FALSE,
319: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
320: x_Return_Status => l_return_status,
321: x_Msg_Count => x_msg_count,

Line 318: p_Commit => FND_API.G_FALSE,

314:
315: -- All of the values have been converted, so call the Create_Qualifier Private API
316: JTF_QUALIFIER_PVT.Update_Qualifier ( p_api_version => 1.0,
317: p_Init_Msg_List => FND_API.G_FALSE,
318: p_Commit => FND_API.G_FALSE,
319: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
320: x_Return_Status => l_return_status,
321: x_Msg_Count => x_msg_count,
322: x_Msg_Data => x_msg_data,

Line 319: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

315: -- All of the values have been converted, so call the Create_Qualifier Private API
316: JTF_QUALIFIER_PVT.Update_Qualifier ( p_api_version => 1.0,
317: p_Init_Msg_List => FND_API.G_FALSE,
318: p_Commit => FND_API.G_FALSE,
319: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
320: x_Return_Status => l_return_status,
321: x_Msg_Count => x_msg_count,
322: x_Msg_Data => x_msg_data,
323: p_Seed_Qual_Rec => p_seed_qual_rec,

Line 328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

324: p_Qual_Usgs_Rec => p_qual_usgs_rec,
325: x_Seed_Qual_Rec => x_seed_qual_rec,
326: x_Qual_Usgs_Rec => x_qual_usgs_rec);
327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;

Line 329: RAISE FND_API.G_EXC_ERROR;

325: x_Seed_Qual_Rec => x_seed_qual_rec,
326: x_Qual_Usgs_Rec => x_qual_usgs_rec);
327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:

Line 330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

326: x_Qual_Usgs_Rec => x_qual_usgs_rec);
327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334: /* save return status */

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334: /* save return status */
335: x_return_status := l_return_status;

Line 344: IF FND_API.To_Boolean ( p_commit )

340: -- End of API body.
341: -------------------------------------------------------------------------------------------------------
342:
343: -- Standard check of p_commit.
344: IF FND_API.To_Boolean ( p_commit )
345: THEN
346: COMMIT WORK;
347: END IF;
348:

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361:
362:
363: EXCEPTION
364:
365: WHEN FND_API.G_EXC_ERROR THEN
366: ROLLBACK TO UPDATE_QUALIFIER_PUB;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368:
369: FND_MSG_PUB.Count_And_Get

Line 367: x_return_status := FND_API.G_RET_STS_ERROR ;

363: EXCEPTION
364:
365: WHEN FND_API.G_EXC_ERROR THEN
366: ROLLBACK TO UPDATE_QUALIFIER_PUB;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368:
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data

Line 374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO UPDATE_QUALIFIER_PUB;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377:
378: FND_MSG_PUB.Count_And_Get

Line 376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

372: );
373:
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO UPDATE_QUALIFIER_PUB;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377:
378: FND_MSG_PUB.Count_And_Get
379: ( p_count => x_msg_count,
380: p_data => x_msg_data

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

382:
383:
384: WHEN OTHERS THEN
385: ROLLBACK TO UPDATE_QUALIFIER_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387:
388: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
390: END IF;

Line 420: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

416: -- p_Qual_Usgs_Id NUMBER
417: --
418: -- Optional
419: -- Parameter Name Data Type Default
420: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
421: -- P_Commit VARCHAR2 FND_API.G_FALSE
422: --
423: -- OUT :
424: -- Parameter Name Data Type

Line 421: -- P_Commit VARCHAR2 FND_API.G_FALSE

417: --
418: -- Optional
419: -- Parameter Name Data Type Default
420: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE
421: -- P_Commit VARCHAR2 FND_API.G_FALSE
422: --
423: -- OUT :
424: -- Parameter Name Data Type
425: -- x_Return_Status VARCHAR2(1)

Line 437: p_Init_Msg_List IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,

433: -- End of Comments
434: --
435: PROCEDURE Delete_Qualifier
436: (p_api_version IN NUMBER,
437: p_Init_Msg_List IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
438: p_Commit IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
439: x_Return_Status OUT NOCOPY VARCHAR2,
440: x_Msg_Count OUT NOCOPY NUMBER,
441: x_Msg_Data OUT NOCOPY VARCHAR2,

Line 438: p_Commit IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,

434: --
435: PROCEDURE Delete_Qualifier
436: (p_api_version IN NUMBER,
437: p_Init_Msg_List IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
438: p_Commit IN VARCHAR2, -- 2372550: JDOCHERT : 05/1402 -- := FND_API.G_FALSE,
439: x_Return_Status OUT NOCOPY VARCHAR2,
440: x_Msg_Count OUT NOCOPY NUMBER,
441: x_Msg_Data OUT NOCOPY VARCHAR2,
442: p_Seeded_Qual_Id IN NUMBER,

Line 458: IF NOT FND_API.Compatible_API_Call (

454: -- Standard Start of API savepoint;
455: SAVEPOINT DELETE_QUALIFIER_PUB;
456:
457: -- Standard call to check for call compatibility.
458: IF NOT FND_API.Compatible_API_Call (
459: l_api_version,
460: p_api_version ,
461: l_api_name,
462: G_PKG_NAME)

Line 464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

460: p_api_version ,
461: l_api_name,
462: G_PKG_NAME)
463: THEN
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: END IF;
466:
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list )

Line 468: IF FND_API.to_Boolean( p_init_msg_list )

464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: END IF;
466:
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list )
469: THEN
470: FND_MSG_PUB.initialize;
471: END IF;
472:

Line 485: l_return_status := FND_API.G_RET_STS_SUCCESS;

481: -- Start of API body.
482: -------------------------------------------------------------------------------------------------------
483:
484: -- Initialize API return status to success
485: l_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487:
488: -- All of the values have been converted, so call the Create_Qualifier Private API
489: JTF_QUALIFIER_PVT.Delete_Qualifier ( p_api_version => 1.0,

Line 490: p_Init_Msg_List => FND_API.G_FALSE,

486:
487:
488: -- All of the values have been converted, so call the Create_Qualifier Private API
489: JTF_QUALIFIER_PVT.Delete_Qualifier ( p_api_version => 1.0,
490: p_Init_Msg_List => FND_API.G_FALSE,
491: p_Commit => FND_API.G_FALSE,
492: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
493: x_Return_Status => l_return_status,
494: x_Msg_Count => x_msg_count,

Line 491: p_Commit => FND_API.G_FALSE,

487:
488: -- All of the values have been converted, so call the Create_Qualifier Private API
489: JTF_QUALIFIER_PVT.Delete_Qualifier ( p_api_version => 1.0,
490: p_Init_Msg_List => FND_API.G_FALSE,
491: p_Commit => FND_API.G_FALSE,
492: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
493: x_Return_Status => l_return_status,
494: x_Msg_Count => x_msg_count,
495: x_Msg_Data => x_msg_data,

Line 492: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

488: -- All of the values have been converted, so call the Create_Qualifier Private API
489: JTF_QUALIFIER_PVT.Delete_Qualifier ( p_api_version => 1.0,
490: p_Init_Msg_List => FND_API.G_FALSE,
491: p_Commit => FND_API.G_FALSE,
492: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
493: x_Return_Status => l_return_status,
494: x_Msg_Count => x_msg_count,
495: x_Msg_Data => x_msg_data,
496: p_Seeded_Qual_Id => p_seeded_qual_id,

Line 499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

495: x_Msg_Data => x_msg_data,
496: p_Seeded_Qual_Id => p_seeded_qual_id,
497: p_Qual_Usg_Id => p_qual_usg_id);
498:
499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;

Line 500: RAISE FND_API.G_EXC_ERROR;

496: p_Seeded_Qual_Id => p_seeded_qual_id,
497: p_Qual_Usg_Id => p_qual_usg_id);
498:
499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:

Line 501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

497: p_Qual_Usg_Id => p_qual_usg_id);
498:
499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: /* save return status */

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498:
499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: /* save return status */
506: x_return_status := l_return_status;

Line 515: IF FND_API.To_Boolean ( p_commit )

511: -- End of API body.
512: -------------------------------------------------------------------------------------------------------
513:
514: -- Standard check of p_commit.
515: IF FND_API.To_Boolean ( p_commit )
516: THEN
517: COMMIT WORK;
518: END IF;
519:

Line 536: WHEN FND_API.G_EXC_ERROR THEN

532:
533:
534: EXCEPTION
535:
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO DELETE_QUALIFIER_PUB;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539:
540: FND_MSG_PUB.Count_And_Get

Line 538: x_return_status := FND_API.G_RET_STS_ERROR ;

534: EXCEPTION
535:
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO DELETE_QUALIFIER_PUB;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539:
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO DELETE_QUALIFIER_PUB;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: FND_MSG_PUB.Count_And_Get

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

543: );
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO DELETE_QUALIFIER_PUB;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: FND_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count,
551: p_data => x_msg_data

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

553:
554:
555: WHEN OTHERS THEN
556: ROLLBACK TO DELETE_QUALIFIER_PUB;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558:
559: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
561: END IF;