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

Line 34: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 35: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 36: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

32: PROCEDURE Create_BRMRule
33: ( p_api_version IN NUMBER
34: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
35: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
36: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
37: , x_return_status OUT NOCOPY VARCHAR2
38: , x_msg_count OUT NOCOPY NUMBER
39: , x_msg_data OUT NOCOPY VARCHAR2
40: , p_br_rec IN BRM_Rule_rec_type

Line 65: IF NOT FND_API.Compatible_API_Call( l_api_version

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

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: , p_api_version
67: , l_api_name
68: , G_PKG_NAME)
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. Generate the method ID from the
88: -- sequence, then insert the passed in attributes into the

Line 223: IF FND_API.To_Boolean(p_commit)

219:
220: --
221: -- Standard check of p_commit
222: --
223: IF FND_API.To_Boolean(p_commit)
224: THEN
225: COMMIT WORK;
226: END IF;
227:

Line 236: WHEN FND_API.G_EXC_ERROR

232: , p_data => x_msg_data
233: );
234:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR
237: THEN
238: ROLLBACK TO Create_BRMRule_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR
237: THEN
238: ROLLBACK TO Create_BRMRule_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
241: , p_data => x_msg_data
242: );
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
241: , p_data => x_msg_data
242: );
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
244: THEN
245: ROLLBACK TO Create_BRMRule_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: );
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
244: THEN
245: ROLLBACK TO Create_BRMRule_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
248: , p_data => x_msg_data
249: );
250: WHEN OTHERS

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: );
250: WHEN OTHERS
251: THEN
252: ROLLBACK TO Create_BRMRule_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
257: , l_api_name

Line 294: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

290: -- End of comments
291: --------------------------------------------------------------------------
292: PROCEDURE Update_BRMRule
293: ( p_api_version IN NUMBER
294: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
295: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
296: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
297: , x_return_status OUT NOCOPY VARCHAR2
298: , x_msg_count OUT NOCOPY NUMBER

Line 295: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

291: --------------------------------------------------------------------------
292: PROCEDURE Update_BRMRule
293: ( p_api_version IN NUMBER
294: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
295: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
296: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
297: , x_return_status OUT NOCOPY VARCHAR2
298: , x_msg_count OUT NOCOPY NUMBER
299: , x_msg_data OUT NOCOPY VARCHAR2

Line 296: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

292: PROCEDURE Update_BRMRule
293: ( p_api_version IN NUMBER
294: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
295: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
296: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
297: , x_return_status OUT NOCOPY VARCHAR2
298: , x_msg_count OUT NOCOPY NUMBER
299: , x_msg_data OUT NOCOPY VARCHAR2
300: , p_br_rec IN BRM_Rule_rec_type

Line 320: IF NOT FND_API.Compatible_API_Call( l_api_version

316:
317: --
318: -- Standard call to check for call compatibility
319: --
320: IF NOT FND_API.Compatible_API_Call( l_api_version
321: , p_api_version
322: , l_api_name
323: , G_PKG_NAME)
324: THEN

Line 325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

321: , p_api_version
322: , l_api_name
323: , G_PKG_NAME)
324: THEN
325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
326: END IF;
327:
328: --
329: -- Initialize message list if p_init_msg_list is set to TRUE

Line 331: IF FND_API.To_Boolean(p_init_msg_list)

327:
328: --
329: -- Initialize message list if p_init_msg_list is set to TRUE
330: --
331: IF FND_API.To_Boolean(p_init_msg_list)
332: THEN
333: FND_MSG_PUB.Initialize;
334: END IF;
335:

Line 339: x_return_status := FND_API.G_RET_STS_SUCCESS;

335:
336: --
337: -- Initialize API return status to success
338: --
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:
341: --
342: -- Get new object versio number
343: --

Line 410: IF FND_API.To_Boolean(p_commit)

406:
407: --
408: -- Standard check of p_commit
409: --
410: IF FND_API.To_Boolean(p_commit)
411: THEN
412: COMMIT WORK;
413: END IF;
414:

Line 423: WHEN FND_API.G_EXC_ERROR

419: , p_data => x_msg_data
420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR
424: THEN
425: ROLLBACK TO Update_BRMRule_PVT;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR
424: THEN
425: ROLLBACK TO Update_BRMRule_PVT;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430:

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

427: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
432: THEN
433: ROLLBACK TO Update_BRMRule_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
432: THEN
433: ROLLBACK TO Update_BRMRule_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
436: , p_data => x_msg_data
437: );
438:

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438:
439: WHEN OTHERS
440: THEN
441: ROLLBACK TO Update_BRMRule_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
446: , l_api_name

Line 483: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

479: -- End of comments
480: --------------------------------------------------------------------------
481: PROCEDURE Delete_BRMRule
482: ( p_api_version IN NUMBER
483: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
484: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
485: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
486: , x_return_status OUT NOCOPY VARCHAR2
487: , x_msg_count OUT NOCOPY NUMBER

Line 484: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

480: --------------------------------------------------------------------------
481: PROCEDURE Delete_BRMRule
482: ( p_api_version IN NUMBER
483: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
484: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
485: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
486: , x_return_status OUT NOCOPY VARCHAR2
487: , x_msg_count OUT NOCOPY NUMBER
488: , x_msg_data OUT NOCOPY VARCHAR2

Line 485: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

481: PROCEDURE Delete_BRMRule
482: ( p_api_version IN NUMBER
483: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
484: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
485: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
486: , x_return_status OUT NOCOPY VARCHAR2
487: , x_msg_count OUT NOCOPY NUMBER
488: , x_msg_data OUT NOCOPY VARCHAR2
489: , p_rule_id IN NUMBER

Line 507: IF NOT FND_API.Compatible_API_Call( l_api_version

503:
504: --
505: -- Check version number
506: --
507: IF NOT FND_API.Compatible_API_Call( l_api_version
508: , p_api_version
509: , l_api_name
510: , G_PKG_NAME
511: )

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509: , l_api_name
510: , G_PKG_NAME
511: )
512: THEN
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515:
516: --
517: -- Initialize message list if requested

Line 519: IF FND_API.to_Boolean( p_init_msg_list )

515:
516: --
517: -- Initialize message list if requested
518: --
519: IF FND_API.to_Boolean( p_init_msg_list )
520: THEN
521: FND_MSG_PUB.initialize;
522: END IF;
523:

Line 527: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

523:
524: --
525: -- Initialize return status to SUCCESS
526: --
527: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
528:
529: DELETE FROM JTF_BRM_RULES_TL
530: WHERE RULE_ID = p_rule_id;
531:

Line 551: IF FND_API.To_Boolean( p_commit )

547: THEN
548: RAISE no_data_found;
549: END IF;
550:
551: IF FND_API.To_Boolean( p_commit )
552: THEN
553: COMMIT WORK;
554: END IF;
555:

Line 561: WHEN FND_API.G_EXC_ERROR

557: , p_data => X_MSG_DATA
558: );
559:
560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR
562: THEN
563: ROLLBACK TO Delete_BRMRule_PVT;
564: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 564: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR
562: THEN
563: ROLLBACK TO Delete_BRMRule_PVT;
564: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
566: , p_data => X_MSG_DATA
567: );
568:

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

565: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
566: , p_data => X_MSG_DATA
567: );
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
570: THEN
571: ROLLBACK TO Delete_BRMRule_PVT;
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
570: THEN
571: ROLLBACK TO Delete_BRMRule_PVT;
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
574: , p_data => X_MSG_DATA
575: );
576:

Line 580: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

576:
577: WHEN OTHERS
578: THEN
579: ROLLBACK TO Delete_BRMRule_PVT;
580: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
584: , l_api_name