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

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58: ,x_errorcode => l_error
59: );
60: /** Add error check **/
61: IF (l_success <> 'T') THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64: END doRevoke;
65:
66: PROCEDURE doCalGrant

Line 95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

91: , x_errorcode => l_error
92: );
93: /** Add error check **/
94: IF (l_success <> 'T') THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97: END doCalGrant;
98:
99: PROCEDURE doTasksGrant

Line 129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

125: , p_parameter1 => p_GranterID
126: );
127: /** Add error check **/
128: IF (l_success <> 'T') THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131: END doTasksGrant;
132:
133: PROCEDURE UpdateGrants

Line 142: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

138: ** - a list of Full Access Grantees
139: ** This API will make sure that the proper grants are create/deleted
140: *******************************************************************************/
141: ( p_api_version IN NUMBER
142: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
143: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
144: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
145: , x_return_status OUT NOCOPY VARCHAR2
146: , x_msg_count OUT NOCOPY NUMBER

Line 143: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

139: ** This API will make sure that the proper grants are create/deleted
140: *******************************************************************************/
141: ( p_api_version IN NUMBER
142: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
143: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
144: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
145: , x_return_status OUT NOCOPY VARCHAR2
146: , x_msg_count OUT NOCOPY NUMBER
147: , x_msg_data OUT NOCOPY VARCHAR2

Line 144: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

140: *******************************************************************************/
141: ( p_api_version IN NUMBER
142: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
143: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
144: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
145: , x_return_status OUT NOCOPY VARCHAR2
146: , x_msg_count OUT NOCOPY NUMBER
147: , x_msg_data OUT NOCOPY VARCHAR2
148: , p_GranterID IN VARCHAR2

Line 211: IF NOT FND_API.Compatible_API_Call( l_api_version

207: BEGIN
208: /*****************************************************************************
209: ** Standard call to check for call compatibility
210: *****************************************************************************/
211: IF NOT FND_API.Compatible_API_Call( l_api_version
212: , p_api_version
213: , l_api_name
214: , G_PKG_NAME
215: )

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: , l_api_name
214: , G_PKG_NAME
215: )
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: /*****************************************************************************
221: ** Initialize message list if p_init_msg_list is set to TRUE

Line 223: IF FND_API.To_Boolean(p_init_msg_list)

219:
220: /*****************************************************************************
221: ** Initialize message list if p_init_msg_list is set to TRUE
222: *****************************************************************************/
223: IF FND_API.To_Boolean(p_init_msg_list)
224: THEN
225: FND_MSG_PUB.Initialize;
226: END IF;
227:

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227:
228: /*****************************************************************************
229: ** Initialize API return status to success
230: *****************************************************************************/
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: /*****************************************************************************
234: ** Submit JSP will return a comma delimited string, need to break it up
235: ** Merge p_ReadAccess and p_FullAccess into one table of records

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: l_TaskAccessTbl(i).GranteeKey := get_username(l_CalAccessTbl(i).GranteeKey);
262: IF (l_TaskAccessTbl(i).GranteeKey = '-1') THEN
263: fnd_message.set_name('JTF', 'JTF_CAL_USERNAME_NOT_FOUND');
264: fnd_msg_pub.add;
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: l_TaskAccessTbl(i).AccessLevel := jtf_task_security_pvt.READ_PRIVILEGE;
269:

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: l_TaskAccessTbl(i).GranteeKey := get_username(l_CalAccessTbl(i).GranteeKey);
300: IF (l_TaskAccessTbl(i).GranteeKey = '-1') THEN
301: fnd_message.set_name('JTF', 'JTF_CAL_USERNAME_NOT_FOUND');
302: fnd_msg_pub.add;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: l_TaskAccessTbl(i).AccessLevel := jtf_task_security_pvt.FULL_PRIVILEGE;
307:

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: l_instance_set_id := get_instance_set_id(jtf_task_security_pvt.RESOURCE_TASKS_SET);
320: IF ( l_instance_set_id = -1) THEN
321: fnd_message.set_name('JTF', 'JTF_CAL_INST_SET_ID_NOT_FOUND');
322: fnd_msg_pub.add;
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: /** Grant and Revoke Calendar Read and Full Access **/
327: FOR r_cal IN C_CAL LOOP

Line 394: IF FND_API.To_Boolean(p_commit)

390:
391: /*****************************************************************************
392: ** Standard check of p_commit
393: *****************************************************************************/
394: IF FND_API.To_Boolean(p_commit)
395: THEN
396: COMMIT WORK;
397: END IF;
398:

Line 407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

403: , p_data => x_msg_data
404: );
405:
406: EXCEPTION
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
408: THEN
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
411: , p_data => x_msg_data

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

405:
406: EXCEPTION
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
408: THEN
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
411: , p_data => x_msg_data
412: );
413: WHEN OTHERS

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: , p_data => x_msg_data
412: );
413: WHEN OTHERS
414: THEN
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
417: THEN
418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
419: , l_api_name

Line 430: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

426: END UpdateGrants;
427:
428: PROCEDURE RevokeGrants
429: ( p_api_version IN NUMBER
430: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
431: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
432: , x_return_status OUT NOCOPY VARCHAR2
433: , x_msg_count OUT NOCOPY NUMBER
434: , x_msg_data OUT NOCOPY VARCHAR2

Line 431: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

427:
428: PROCEDURE RevokeGrants
429: ( p_api_version IN NUMBER
430: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
431: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
432: , x_return_status OUT NOCOPY VARCHAR2
433: , x_msg_count OUT NOCOPY NUMBER
434: , x_msg_data OUT NOCOPY VARCHAR2
435: , p_resourceId IN VARCHAR2

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

444: l_msg_data VARCHAR2(2000);
445: l_grant_guid RAW(16);
446:
447: BEGIN
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449:
450: l_grant_guid := get_grant_guid(p_resourceId => p_resourceId,
451: p_groupId => p_groupId);
452: IF (l_grant_guid IS NOT NULL) THEN

Line 461: IF (l_return_status <> FND_API.G_TRUE)

457: x_success => l_return_status,
458: x_errorcode => x_msg_data
459: );
460:
461: IF (l_return_status <> FND_API.G_TRUE)
462: THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: END IF;

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: );
460:
461: IF (l_return_status <> FND_API.G_TRUE)
462: THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: END IF;
466:
467: /*****************************************************************************

Line 474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

470: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
471: , p_data => x_msg_data
472: );
473: EXCEPTION
474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
475: THEN
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
478: , p_data => x_msg_data

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: );
473: EXCEPTION
474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
475: THEN
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
478: , p_data => x_msg_data
479: );
480: WHEN OTHERS

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

478: , p_data => x_msg_data
479: );
480: WHEN OTHERS
481: THEN
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
486: , l_api_name

Line 497: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

493: END RevokeGrants;
494:
495: PROCEDURE InvokeGrants
496: ( p_api_version IN NUMBER
497: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
498: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
499: , x_return_status OUT NOCOPY VARCHAR2
500: , x_msg_count OUT NOCOPY NUMBER
501: , x_msg_data OUT NOCOPY VARCHAR2

Line 498: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

494:
495: PROCEDURE InvokeGrants
496: ( p_api_version IN NUMBER
497: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
498: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
499: , x_return_status OUT NOCOPY VARCHAR2
500: , x_msg_count OUT NOCOPY NUMBER
501: , x_msg_data OUT NOCOPY VARCHAR2
502: , p_resourceId IN VARCHAR2

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: l_full_access CONSTANT VARCHAR2(30) := 'JTF_CAL_FULL_ACCESS';
516: l_return BOOLEAN;
517:
518: BEGIN
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520: l_return := has_access_level( p_resourceId => p_resourceId
521: , p_groupId => p_groupId
522: );
523:

Line 567: IF (l_return_status <> FND_API.G_TRUE)

563: , x_grant_guid => l_grant_guid
564: , x_success => l_return_status
565: , x_errorcode => l_msg_data
566: );
567: IF (l_return_status <> FND_API.G_TRUE)
568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571:

Line 569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

565: , x_errorcode => l_msg_data
566: );
567: IF (l_return_status <> FND_API.G_TRUE)
568: THEN
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571:
572: /*****************************************************************************
573: ** Standard call to get message count and if count is > 1, get message info

Line 580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

576: , p_data => x_msg_data
577: );
578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
581: THEN
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
584: , p_data => x_msg_data

Line 582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
581: THEN
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
584: , p_data => x_msg_data
585: );
586: WHEN OTHERS

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: , p_data => x_msg_data
585: );
586: WHEN OTHERS
587: THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
590: THEN
591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
592: , l_api_name