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

Line 41: -- Default = FND_API.G_FALSE

37: -- Parameters :
38: -- IN :
39: -- p_api_version_number IN NUMBER Required
40: -- p_init_msg_list IN VARCHAR2 Optional
41: -- Default = FND_API.G_FALSE
42: -- p_profile_id IN NUMBER
43: -- p_profile_name IN VARCHAR2
44: -- p_profile_type IN VARCHAR2
45: -- p_profile_desc IN VARCHAR2

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

71: --******************************************************************************
72:
73: PROCEDURE Create_Profile
74: ( p_api_version_number IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_profile_id IN NUMBER,
78: p_profile_name IN VARCHAR2 := NULL,
79: p_profile_type IN VARCHAR2 := NULL,

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

72:
73: PROCEDURE Create_Profile
74: ( p_api_version_number IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_profile_id IN NUMBER,
78: p_profile_name IN VARCHAR2 := NULL,
79: p_profile_type IN VARCHAR2 := NULL,
80: p_profile_desc IN VARCHAR2 := NULL,

Line 92: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

88: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89: )IS
90: l_api_version_number NUMBER := p_api_version_number;
91: l_api_name CONSTANT VARCHAR2(30) := 'Create Profile';
92: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
93:
94:
95: BEGIN
96:

Line 103: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

99: -- Standard Start of API savepoint
100: SAVEPOINT CREATE_JTF_PERZ_PROFILE_PUB;
101:
102: -- Standard call to check for call compatibility.
103: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
104: -- THEN
105: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: -- END IF;
107:

Line 105: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

101:
102: -- Standard call to check for call compatibility.
103: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
104: -- THEN
105: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: -- END IF;
107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: IF FND_API.to_Boolean( p_init_msg_list )

Line 109: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111: FND_MSG_PUB.initialize;
112: END IF;
113:
114: -- Initialize API return status to success
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: JTF_PERZ_PROFILE_PVT.Create_Profile
118: ( l_api_version_number,
119: p_init_msg_list,

Line 140: IF FND_API.To_Boolean ( p_commit )

136: --
137: -- 7. Commit the whole thing
138:
139: -- Standard check of p_commit.
140: IF FND_API.To_Boolean ( p_commit )
141: THEN
142: COMMIT WORK;
143: END IF;
144:

Line 155: WHEN FND_API.G_EXC_ERROR THEN

151: );
152:
153: EXCEPTION
154:
155: WHEN FND_API.G_EXC_ERROR THEN
156:
157: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.Count_And_Get

Line 158: x_return_status := FND_API.G_RET_STS_ERROR ;

154:
155: WHEN FND_API.G_EXC_ERROR THEN
156:
157: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );

Line 169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

165: THEN
166: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
167: END IF;
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170:
171: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173: FND_MSG_PUB.Count_And_Get

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170:
171: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173: FND_MSG_PUB.Count_And_Get
174: ( p_count => x_msg_count,
175: p_data => x_msg_data
176: );

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

182:
183: WHEN OTHERS THEN
184:
185: ROLLBACK TO CREATE_JTF_PERZ_PROFILE_PUB;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: FND_MSG_PUB.Count_And_Get
188: ( p_count => x_msg_count,
189: p_data => x_msg_data
190: );

Line 215: -- Default = FND_API.G_FALSE

211: -- Parameters :
212: -- IN :
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional
215: -- Default = FND_API.G_FALSE
216: -- p_profile_id IN NUMBER Optional
217: -- p_profile_name IN VARCHAR2 Optional
218: -- p_profile_type IN VARCHAR2
219: -- p_profile_desc IN VARCHAR2

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

241:
242: --******************************************************************************
243: PROCEDURE Update_Profile
244: ( p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
247: p_profile_id IN NUMBER,
248: p_profile_name IN VARCHAR2,
249: p_profile_type IN VARCHAR2,

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

242: --******************************************************************************
243: PROCEDURE Update_Profile
244: ( p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
247: p_profile_id IN NUMBER,
248: p_profile_name IN VARCHAR2,
249: p_profile_type IN VARCHAR2,
250: p_profile_desc IN VARCHAR2,

Line 262: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

258: )IS
259:
260: l_api_version_number NUMBER := p_api_version_number;
261: l_api_name CONSTANT VARCHAR2(30) := 'Update Profile';
262: l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
263:
264:
265: BEGIN
266:

Line 272: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

268:
269: -- Standard Start of API savepoint
270: SAVEPOINT UPDATE_JTF_PERZ_PROFILE_PUB;
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276:

Line 274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

270: SAVEPOINT UPDATE_JTF_PERZ_PROFILE_PUB;
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276:
277: -- Initialize message list if p_init_msg_list is set to TRUE.
278: IF FND_API.to_Boolean( p_init_msg_list )

Line 278: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: FND_MSG_PUB.initialize;
281: END IF;
282: -- -- Initialize API return status to success
283: if x_return_status is null then
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285: end if;
286:
287:
288: JTF_PERZ_PROFILE_PVT.Update_Profile

Line 312: IF FND_API.To_Boolean ( p_commit )

308: --
309: -- 7. Commit the whole thing
310:
311: -- Standard check of p_commit.
312: IF FND_API.To_Boolean ( p_commit )
313: THEN
314: COMMIT WORK;
315: END IF;
316:

Line 328: WHEN FND_API.G_EXC_ERROR THEN

324:
325:
326: EXCEPTION
327:
328: WHEN FND_API.G_EXC_ERROR THEN
329:
330: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332: FND_MSG_PUB.Count_And_Get

Line 331: x_return_status := FND_API.G_RET_STS_ERROR ;

327:
328: WHEN FND_API.G_EXC_ERROR THEN
329:
330: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count,
334: p_data => x_msg_data
335: );

Line 342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

338: THEN
339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
340: END IF;
341:
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343:
344: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:

Line 345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

341:
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343:
344: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346:
347: FND_MSG_PUB.Count_And_Get
348: ( p_count => x_msg_count,
349: p_data => x_msg_data

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

356:
357: WHEN OTHERS THEN
358:
359: ROLLBACK TO UPDATE_JTF_PERZ_PROFILE_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361:
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data

Line 384: -- Default = FND_API.G_FALSE

380: -- Parameters :
381: -- IN :
382: -- p_api_version_number IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Optional
384: -- Default = FND_API.G_FALSE
385: -- p_profile_id IN NUMBER Optional
386: -- p_profile_name IN VARCHAR2 Optional
387: -- p_profile_type IN VARCHAR2
388: -- p_profile_desc IN VARCHAR2

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

405:
406: --
407: PROCEDURE Get_Profile
408: ( p_api_version_number IN NUMBER,
409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
410:
411: p_profile_id IN NUMBER,
412: p_profile_name IN VARCHAR2,
413: p_profile_type IN VARCHAR2,

Line 425: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

421: )IS
422:
423: l_api_version_number NUMBER := p_api_version_number;
424: l_api_name CONSTANT VARCHAR2(30) := 'Create Profile';
425: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
426:
427:
428: BEGIN
429:

Line 433: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

429:
430: -- ******* Standard Begins ********
431:
432: -- Standard call to check for call compatibility.
433: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
434: -- THEN
435: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: -- END IF;
437:

Line 435: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431:
432: -- Standard call to check for call compatibility.
433: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
434: -- THEN
435: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: -- END IF;
437:
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list )

Line 439: IF FND_API.to_Boolean( p_init_msg_list )

435: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: -- END IF;
437:
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list )
440: THEN
441: FND_MSG_PUB.initialize;
442: END IF;
443:

Line 445: l_return_status := FND_API.G_RET_STS_SUCCESS;

441: FND_MSG_PUB.initialize;
442: END IF;
443:
444: -- Initialize API return status to success
445: l_return_status := FND_API.G_RET_STS_SUCCESS;
446:
447: JTF_PERZ_PROFILE_PVT.Get_Profile
448: ( l_api_version_number,
449: p_init_msg_list,

Line 460: if (l_return_status = FND_API.G_RET_STS_ERROR) then

456: x_msg_count,
457: x_msg_data
458: );
459:
460: if (l_return_status = FND_API.G_RET_STS_ERROR) then
461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: elsif(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: else

Line 461: x_return_status := FND_API.G_RET_STS_ERROR ;

457: x_msg_data
458: );
459:
460: if (l_return_status = FND_API.G_RET_STS_ERROR) then
461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: elsif(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: else
465: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 462: elsif(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

458: );
459:
460: if (l_return_status = FND_API.G_RET_STS_ERROR) then
461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: elsif(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: else
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: end if;

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459:
460: if (l_return_status = FND_API.G_RET_STS_ERROR) then
461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: elsif(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: else
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: end if;
467: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS;

461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: elsif(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: else
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: end if;
467: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
468: -- x_profile_tbl(1).PROFILE_ID := 786;
469: -- x_profile_tbl(1).PROFILE_NAME := 'cchandra';

Line 467: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: else
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: end if;
467: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
468: -- x_profile_tbl(1).PROFILE_ID := 786;
469: -- x_profile_tbl(1).PROFILE_NAME := 'cchandra';
470: -- x_profile_tbl(1).PROFILE_TYPE := 'TYPE';
471: --