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

Line 33: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

29: -- End of comments
30: --------------------------------------------------------------------------
31: PROCEDURE Create_BRMParameter
32: ( p_api_version IN NUMBER
33: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
34: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
35: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
36: , x_return_status OUT NOCOPY VARCHAR2
37: , x_msg_count OUT NOCOPY NUMBER

Line 34: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

30: --------------------------------------------------------------------------
31: PROCEDURE Create_BRMParameter
32: ( p_api_version IN NUMBER
33: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
34: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
35: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
36: , x_return_status OUT NOCOPY VARCHAR2
37: , x_msg_count OUT NOCOPY NUMBER
38: , x_msg_data OUT NOCOPY VARCHAR2

Line 35: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

31: PROCEDURE Create_BRMParameter
32: ( p_api_version IN NUMBER
33: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
34: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
35: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
36: , x_return_status OUT NOCOPY VARCHAR2
37: , x_msg_count OUT NOCOPY NUMBER
38: , x_msg_data OUT NOCOPY VARCHAR2
39: , p_bp_rec IN BRM_PARAMETER_rec_type

Line 64: IF NOT FND_API.Compatible_API_Call( l_api_version

60:
61: --
62: -- Standard call to check for call compatibility
63: --
64: IF NOT FND_API.Compatible_API_Call( l_api_version
65: , p_api_version
66: , l_api_name
67: , G_PKG_NAME
68: )

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: , l_api_name
67: , G_PKG_NAME
68: )
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: --
74: -- Initialize message list if p_init_msg_list is set to TRUE

Line 76: IF FND_API.To_Boolean(p_init_msg_list)

72:
73: --
74: -- Initialize message list if p_init_msg_list is set to TRUE
75: --
76: IF FND_API.To_Boolean(p_init_msg_list)
77: THEN
78: FND_MSG_PUB.Initialize;
79: END IF;
80:

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80:
81: --
82: -- Initialize API return status to success
83: --
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: -------------------------------------------------------------------------
87: -- Perform the database operation. Set the parameter ID to 1, then insert
88: -- the passed in attributes into the JTF_BRM_PARAMETERS table.

Line 185: IF FND_API.To_Boolean(p_commit)

181:
182: --
183: -- Standard check of p_commit
184: --
185: IF FND_API.To_Boolean(p_commit)
186: THEN
187: COMMIT WORK;
188: END IF;
189:

Line 198: WHEN FND_API.G_EXC_ERROR

194: , p_data => x_msg_data
195: );
196:
197: EXCEPTION
198: WHEN FND_API.G_EXC_ERROR
199: THEN
200: ROLLBACK TO Create_BRMParameter_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197: EXCEPTION
198: WHEN FND_API.G_EXC_ERROR
199: THEN
200: ROLLBACK TO Create_BRMParameter_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
203: , p_data => x_msg_data
204: );
205:

Line 206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
203: , p_data => x_msg_data
204: );
205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
207: THEN
208: ROLLBACK TO Create_BRMParameter_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205:
206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
207: THEN
208: ROLLBACK TO Create_BRMParameter_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
211: , p_data => x_msg_data
212: );
213: WHEN OTHERS

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: );
213: WHEN OTHERS
214: THEN
215: ROLLBACK TO Create_BRMParameter_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
220: , l_api_name

Line 256: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

252: -- End of comments
253: --------------------------------------------------------------------------
254: PROCEDURE Update_BRMParameter
255: ( p_api_version IN NUMBER
256: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
257: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
258: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
259: , x_return_status OUT NOCOPY VARCHAR2
260: , x_msg_count OUT NOCOPY NUMBER

Line 257: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

253: --------------------------------------------------------------------------
254: PROCEDURE Update_BRMParameter
255: ( p_api_version IN NUMBER
256: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
257: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
258: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
259: , x_return_status OUT NOCOPY VARCHAR2
260: , x_msg_count OUT NOCOPY NUMBER
261: , x_msg_data OUT NOCOPY VARCHAR2

Line 258: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

254: PROCEDURE Update_BRMParameter
255: ( p_api_version IN NUMBER
256: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
257: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
258: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
259: , x_return_status OUT NOCOPY VARCHAR2
260: , x_msg_count OUT NOCOPY NUMBER
261: , x_msg_data OUT NOCOPY VARCHAR2
262: , p_bp_rec IN BRM_Parameter_rec_type

Line 282: IF NOT FND_API.Compatible_API_Call( l_api_version

278:
279: --
280: -- Standard call to check for call compatibility
281: --
282: IF NOT FND_API.Compatible_API_Call( l_api_version
283: , p_api_version
284: , l_api_name
285: , G_PKG_NAME
286: )

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 294: IF FND_API.To_Boolean(p_init_msg_list)

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

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298:
299: --
300: -- Initialize API return status to success
301: --
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: --
305: -- Get a new object version number
306: --

Line 355: IF FND_API.To_Boolean(p_commit)

351:
352: --
353: -- Standard check of p_commit
354: --
355: IF FND_API.To_Boolean(p_commit)
356: THEN
357: COMMIT WORK;
358: END IF;
359:

Line 368: WHEN FND_API.G_EXC_ERROR

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

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR
369: THEN
370: ROLLBACK TO Update_BRMParameter_PVT;
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
373: , p_data => x_msg_data
374: );
375:

Line 376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

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

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
377: THEN
378: ROLLBACK TO Update_BRMParameter_PVT;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
381: , p_data => x_msg_data
382: );
383:

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 426: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

422: -- End of comments
423: --------------------------------------------------------------------------
424: PROCEDURE Delete_BRMParameter
425: ( p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
427: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
428: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
429: , x_return_status OUT NOCOPY VARCHAR2
430: , x_msg_count OUT NOCOPY NUMBER

Line 427: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

423: --------------------------------------------------------------------------
424: PROCEDURE Delete_BRMParameter
425: ( p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
427: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
428: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
429: , x_return_status OUT NOCOPY VARCHAR2
430: , x_msg_count OUT NOCOPY NUMBER
431: , x_msg_data OUT NOCOPY VARCHAR2

Line 428: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

424: PROCEDURE Delete_BRMParameter
425: ( p_api_version IN NUMBER
426: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
427: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
428: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
429: , x_return_status OUT NOCOPY VARCHAR2
430: , x_msg_count OUT NOCOPY NUMBER
431: , x_msg_data OUT NOCOPY VARCHAR2
432: , p_parameter_id IN NUMBER

Line 450: IF NOT FND_API.Compatible_API_Call( l_api_version

446:
447: --
448: -- Check version number
449: --
450: IF NOT FND_API.Compatible_API_Call( l_api_version
451: , p_api_version
452: , l_api_name
453: , G_PKG_NAME
454: )

Line 456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: , l_api_name
453: , G_PKG_NAME
454: )
455: THEN
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458:
459: --
460: -- Initialize message list if requested

Line 462: IF FND_API.to_Boolean( p_init_msg_list )

458:
459: --
460: -- Initialize message list if requested
461: --
462: IF FND_API.to_Boolean( p_init_msg_list )
463: THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466:

Line 470: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

466:
467: --
468: -- Initialize return status to SUCCESS
469: --
470: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
471:
472: DELETE FROM JTF_BRM_PARAMETERS
473: WHERE PARAMETER_ID = p_parameter_id;
474:

Line 480: IF FND_API.To_Boolean( p_commit )

476: THEN
477: RAISE no_data_found;
478: END IF;
479:
480: IF FND_API.To_Boolean( p_commit )
481: THEN
482: COMMIT WORK;
483: END IF;
484:

Line 490: WHEN FND_API.G_EXC_ERROR

486: , p_data => X_MSG_DATA
487: );
488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR
491: THEN
492: ROLLBACK TO Delete_BRMParameter_PVT;
493: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 493: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR
491: THEN
492: ROLLBACK TO Delete_BRMParameter_PVT;
493: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
495: , p_data => X_MSG_DATA
496: );
497:

Line 498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

494: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
495: , p_data => X_MSG_DATA
496: );
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
499: THEN
500: ROLLBACK TO Delete_BRMParameter_PVT;
501: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
502: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 501: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
499: THEN
500: ROLLBACK TO Delete_BRMParameter_PVT;
501: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
502: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
503: , p_data => X_MSG_DATA
504: );
505:

Line 509: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

505:
506: WHEN OTHERS
507: THEN
508: ROLLBACK TO Delete_BRMParameter_PVT;
509: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
510: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
513: , l_api_name