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.AMV_USER_PVT dependencies on AMV_UTILITY_PVT

Line 247: AMV_UTILITY_PVT.Get_UserInfo(

243: --
244: BEGIN
245: SAVEPOINT Add_Access_helper_PVT;
246: -- Get the current (login) user id.
247: AMV_UTILITY_PVT.Get_UserInfo(
248: x_user_id => l_current_user_id,
249: x_login_id => l_current_login_id,
250: x_resource_id => l_current_resource_id,
251: x_user_status => l_current_user_status

Line 341: AMV_UTILITY_PVT.Get_UserInfo(

337: --
338: BEGIN
339: SAVEPOINT Update_Access_helper_PVT;
340: -- Get the current (login) user id.
341: AMV_UTILITY_PVT.Get_UserInfo(
342: x_user_id => l_current_user_id,
343: x_login_id => l_current_login_id,
344: x_resource_id => l_current_resource_id,
345: x_user_status => l_current_user_status

Line 448: AMV_UTILITY_PVT.Get_UserInfo(

444: END IF;
445: -- Initialize API return status to success
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447: -- Get the current (login) user id.
448: AMV_UTILITY_PVT.Get_UserInfo(
449: x_user_id => l_current_user_id,
450: x_login_id => l_current_login_id,
451: x_resource_id => l_current_resource_id,
452: x_user_status => l_current_user_status

Line 468: AMV_UTILITY_PVT.Get_ResourceId

464: END IF;
465: IF (p_user_id = l_current_user_id) THEN
466: x_resource_id := l_current_resource_id;
467: ELSE
468: AMV_UTILITY_PVT.Get_ResourceId
469: (
470: p_user_id => p_user_id,
471: x_resource_id => x_resource_id
472: );

Line 568: AMV_UTILITY_PVT.Get_UserInfo(

564: END IF;
565: -- Initialize API return status to success
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567: -- Get the current (login) user id.
568: AMV_UTILITY_PVT.Get_UserInfo(
569: x_user_id => l_current_user_id,
570: x_login_id => l_current_login_id,
571: x_resource_id => l_current_resource_id,
572: x_user_status => l_current_user_status

Line 649: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

645: l_where_clause || 'ORDER BY r.last_name, r.first_name ';
646: l_sql_statement2 := l_sql_statement2 || l_where_clause;
647:
648: IF (G_DEBUG = TRUE) THEN
649: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
650: END IF;
651: --Execute the SQL statements to get the total count:
652: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN
653: OPEN l_cursor FOR l_sql_statement2;

Line 802: AMV_UTILITY_PVT.Get_UserInfo(

798: END IF;
799: -- Initialize API return status to success
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801: -- Get the current (login) user id.
802: AMV_UTILITY_PVT.Get_UserInfo(
803: x_user_id => l_current_user_id,
804: x_login_id => l_current_login_id,
805: x_resource_id => l_current_resource_id,
806: x_user_status => l_current_user_status

Line 855: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

851: l_where_clause ||fnd_global.local_chr(10)|| 'ORDER BY r.last_name, r.first_name ';
852:
853: l_sql_statement2 := l_sql_statement2 ||fnd_global.local_chr(10)||l_where_clause;
854: IF (G_DEBUG = TRUE) THEN
855: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
856: END IF;
857: --Execute the SQL statements to get the total count:
858: --dbms_output.put_line('l_sql_statement2 : '||l_sql_statement2);
859: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN

Line 1021: AMV_UTILITY_PVT.Get_UserInfo(

1017: END IF;
1018: -- Initialize API return status to success
1019: x_return_status := FND_API.G_RET_STS_SUCCESS;
1020: -- Get the current (login) user id.
1021: AMV_UTILITY_PVT.Get_UserInfo(
1022: x_user_id => l_current_user_id,
1023: x_login_id => l_current_login_id,
1024: x_resource_id => l_current_resource_id,
1025: x_user_status => l_current_user_status

Line 1195: AMV_UTILITY_PVT.Get_UserInfo(

1191: END IF;
1192: -- Initialize API return status to success
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194: -- Get the current (login) user id.
1195: AMV_UTILITY_PVT.Get_UserInfo(
1196: x_user_id => l_current_user_id,
1197: x_login_id => l_current_login_id,
1198: x_resource_id => l_current_resource_id,
1199: x_user_status => l_current_user_status

Line 1382: AMV_UTILITY_PVT.Get_UserInfo(

1378: END IF;
1379: -- Initialize API return status to success
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381: -- Get the current (login) user id.
1382: AMV_UTILITY_PVT.Get_UserInfo(
1383: x_user_id => l_current_user_id,
1384: x_login_id => l_current_login_id,
1385: x_resource_id => l_current_resource_id,
1386: x_user_status => l_current_user_status

Line 1423: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN

1419: l_current_login_id := -1;
1420: l_current_user_id := -1;
1421: END IF;
1422: -- Check if the resource id is valid
1423: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1424: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1426: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1427: FND_MSG_PUB.Add;

Line 1575: AMV_UTILITY_PVT.Get_UserInfo(

1571: END IF;
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574: -- Get the current (login) user id.
1575: AMV_UTILITY_PVT.Get_UserInfo(
1576: x_user_id => l_current_user_id,
1577: x_login_id => l_current_login_id,
1578: x_resource_id => l_current_resource_id,
1579: x_user_status => l_current_user_status

Line 1616: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN

1612: l_current_login_id := -1;
1613: l_current_user_id := -1;
1614: END IF;
1615: -- Check if the resource id is valid
1616: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1617: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1619: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1620: FND_MSG_PUB.Add;

Line 1895: AMV_UTILITY_PVT.Get_UserInfo(

1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892: x_role_id_varray := AMV_NUMBER_VARRAY_TYPE();
1893: x_role_code_varray := AMV_CHAR_VARRAY_TYPE();
1894: -- Get the current (login) user id.
1895: AMV_UTILITY_PVT.Get_UserInfo(
1896: x_user_id => l_current_user_id,
1897: x_login_id => l_current_login_id,
1898: x_resource_id => l_current_resource_id,
1899: x_user_status => l_current_user_status

Line 1918: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN

1914: l_current_login_id := -1;
1915: l_current_user_id := -1;
1916: END IF;
1917: -- Check if the resource id is valid
1918: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1919: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1921: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1922: FND_MSG_PUB.Add;

Line 2078: AMV_UTILITY_PVT.Get_UserInfo(

2074: -- Initialize API return status to success
2075: x_return_status := FND_API.G_RET_STS_SUCCESS;
2076: x_result_flag := FND_API.G_FALSE;
2077: -- Get the current (login) user id.
2078: AMV_UTILITY_PVT.Get_UserInfo(
2079: x_user_id => l_current_user_id,
2080: x_login_id => l_current_login_id,
2081: x_resource_id => l_current_resource_id,
2082: x_user_status => l_current_user_status

Line 2106: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN

2102: l_resource_id := l_current_resource_id;
2103: ELSE
2104: l_resource_id := p_resource_id;
2105: -- Check if the resource id is valid
2106: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
2107: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2108: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
2109: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
2110: FND_MSG_PUB.Add;

Line 2538: AMV_UTILITY_PVT.Get_UserInfo(

2534: END IF;
2535: -- Initialize API return status to success
2536: x_return_status := FND_API.G_RET_STS_SUCCESS;
2537: -- Get the current (login) user id.
2538: AMV_UTILITY_PVT.Get_UserInfo(
2539: x_user_id => l_current_user_id,
2540: x_login_id => l_current_login_id,
2541: x_resource_id => l_current_resource_id,
2542: x_user_status => l_current_user_status

Line 2579: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

2575: l_current_login_id := -1;
2576: l_current_user_id := -1;
2577: END IF;
2578: -- Check if the group id is valid
2579: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2582: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2583: FND_MSG_PUB.Add;

Line 2732: AMV_UTILITY_PVT.Get_UserInfo(

2728: END IF;
2729: -- Initialize API return status to success
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;
2731: -- Get the current (login) user id.
2732: AMV_UTILITY_PVT.Get_UserInfo(
2733: x_user_id => l_current_user_id,
2734: x_login_id => l_current_login_id,
2735: x_resource_id => l_current_resource_id,
2736: x_user_status => l_current_user_status

Line 2773: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

2769: l_current_login_id := -1;
2770: l_current_user_id := -1;
2771: END IF;
2772: -- Check if the Group id is valid
2773: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2774: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2775: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2776: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2777: FND_MSG_PUB.Add;

Line 3051: AMV_UTILITY_PVT.Get_UserInfo(

3047: x_return_status := FND_API.G_RET_STS_SUCCESS;
3048: x_role_id_varray := AMV_NUMBER_VARRAY_TYPE();
3049: x_role_code_varray := AMV_CHAR_VARRAY_TYPE();
3050: -- Get the current (login) user id.
3051: AMV_UTILITY_PVT.Get_UserInfo(
3052: x_user_id => l_current_user_id,
3053: x_login_id => l_current_login_id,
3054: x_resource_id => l_current_resource_id,
3055: x_user_status => l_current_user_status

Line 3074: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

3070: l_current_login_id := -1;
3071: l_current_user_id := -1;
3072: END IF;
3073: -- Check if the group id is valid
3074: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3075: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3076: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3077: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3078: FND_MSG_PUB.Add;

Line 3188: AMV_UTILITY_PVT.Get_UserInfo(

3184: -- Initialize API return status to success
3185: x_return_status := FND_API.G_RET_STS_SUCCESS;
3186: x_result_flag := FND_API.G_FALSE;
3187: -- Get the current (login) user id.
3188: AMV_UTILITY_PVT.Get_UserInfo(
3189: x_user_id => l_current_user_id,
3190: x_login_id => l_current_login_id,
3191: x_resource_id => l_current_resource_id,
3192: x_user_status => l_current_user_status

Line 3206: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;
3204: END IF;
3205: -- Check if the resource id is valid
3206: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3207: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3208: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3209: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3210: FND_MSG_PUB.Add;

Line 3334: AMV_UTILITY_PVT.Get_UserInfo(

3330: END IF;
3331: -- Initialize API return status to success
3332: x_return_status := FND_API.G_RET_STS_SUCCESS;
3333: -- Get the current (login) user id.
3334: AMV_UTILITY_PVT.Get_UserInfo(
3335: x_user_id => l_current_user_id,
3336: x_login_id => l_current_login_id,
3337: x_resource_id => l_current_resource_id,
3338: x_user_status => l_current_user_status

Line 3667: AMV_UTILITY_PVT.Get_UserInfo(

3663: END IF;
3664: -- Initialize API return status to success
3665: x_return_status := FND_API.G_RET_STS_SUCCESS;
3666: -- Get the current (login) user id.
3667: AMV_UTILITY_PVT.Get_UserInfo(
3668: x_user_id => l_current_user_id,
3669: x_login_id => l_current_login_id,
3670: x_resource_id => l_current_resource_id,
3671: x_user_status => l_current_user_status

Line 3708: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

3704: l_current_login_id := -1;
3705: l_current_user_id := -1;
3706: END IF;
3707: -- Check if the group id is valid
3708: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3709: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3710: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3711: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3712: FND_MSG_PUB.Add;

Line 3890: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

3886: -- Initialize API return status to success
3887: x_return_status := FND_API.G_RET_STS_SUCCESS;
3888: -- Check if the group id is valid
3889: IF (p_group_id IS NOT NULL AND p_group_id <> FND_API.G_MISS_NUM) THEN
3890: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3893: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3894: FND_MSG_PUB.Add;

Line 4049: AMV_UTILITY_PVT.Get_UserInfo(

4045: END IF;
4046: -- Initialize API return status to success
4047: x_return_status := FND_API.G_RET_STS_SUCCESS;
4048: -- Get the current (login) user id.
4049: AMV_UTILITY_PVT.Get_UserInfo(
4050: x_user_id => l_current_user_id,
4051: x_login_id => l_current_login_id,
4052: x_resource_id => l_current_resource_id,
4053: x_user_status => l_current_user_status

Line 4195: AMV_UTILITY_PVT.Get_UserInfo(

4191: END IF;
4192: -- Initialize API return status to success
4193: x_return_status := FND_API.G_RET_STS_SUCCESS;
4194: -- Get the current (login) user id.
4195: AMV_UTILITY_PVT.Get_UserInfo(
4196: x_user_id => l_current_user_id,
4197: x_login_id => l_current_login_id,
4198: x_resource_id => l_current_resource_id,
4199: x_user_status => l_current_user_status

Line 4281: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

4277: l_where_clause || 'ORDER BY g.group_name ';
4278: l_sql_statement2 := l_sql_statement2 ||
4279: l_where_clause;
4280: IF (G_DEBUG = TRUE) THEN
4281: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
4282: END IF;
4283: --Execute the SQL statements to get the total count:
4284: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN
4285: OPEN l_cursor FOR l_sql_statement2;

Line 4441: AMV_UTILITY_PVT.Get_UserInfo(

4437: END IF;
4438: -- Initialize API return status to success
4439: x_return_status := FND_API.G_RET_STS_SUCCESS;
4440: -- Get the current (login) user id.
4441: AMV_UTILITY_PVT.Get_UserInfo(
4442: x_user_id => l_current_user_id,
4443: x_login_id => l_current_login_id,
4444: x_resource_id => l_current_resource_id,
4445: x_user_status => l_current_user_status

Line 4494: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);

4490: l_where_clause || 'ORDER BY g.group_name ';
4491: l_sql_statement2 := l_sql_statement2 ||
4492: l_where_clause;
4493: IF (G_DEBUG = TRUE) THEN
4494: AMV_UTILITY_PVT.PRINT_DEBUG_MESSAGE(l_sql_statement);
4495: END IF;
4496: --Execute the SQL statements to get the total count:
4497: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN
4498: OPEN l_cursor FOR l_sql_statement2;

Line 4652: AMV_UTILITY_PVT.Get_UserInfo(

4648: END IF;
4649: -- Initialize API return status to success
4650: x_return_status := FND_API.G_RET_STS_SUCCESS;
4651: -- Get the current (login) user id.
4652: AMV_UTILITY_PVT.Get_UserInfo(
4653: x_user_id => l_current_user_id,
4654: x_login_id => l_current_login_id,
4655: x_resource_id => l_current_resource_id,
4656: x_user_status => l_current_user_status

Line 4693: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

4689: l_current_login_id := -1;
4690: l_current_user_id := -1;
4691: END IF;
4692: -- Check if the group id is valid
4693: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4695: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4696: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4697: FND_MSG_PUB.Add;

Line 4702: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN

4698: END IF;
4699: RAISE FND_API.G_EXC_ERROR;
4700: END IF;
4701: -- Check if the resource id is valid
4702: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
4703: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4704: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
4705: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
4706: FND_MSG_PUB.Add;

Line 4813: AMV_UTILITY_PVT.Get_UserInfo(

4809: END IF;
4810: -- Initialize API return status to success
4811: x_return_status := FND_API.G_RET_STS_SUCCESS;
4812: -- Get the current (login) user id.
4813: AMV_UTILITY_PVT.Get_UserInfo(
4814: x_user_id => l_current_user_id,
4815: x_login_id => l_current_login_id,
4816: x_resource_id => l_current_resource_id,
4817: x_user_status => l_current_user_status

Line 4854: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

4850: l_current_login_id := -1;
4851: l_current_user_id := -1;
4852: END IF;
4853: -- Check if the group id is valid
4854: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4855: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4856: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4857: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4858: FND_MSG_PUB.Add;

Line 4968: AMV_UTILITY_PVT.Get_UserInfo(

4964: END IF;
4965: -- Initialize API return status to success
4966: x_return_status := FND_API.G_RET_STS_SUCCESS;
4967: -- Get the current (login) user id.
4968: AMV_UTILITY_PVT.Get_UserInfo(
4969: x_user_id => l_current_user_id,
4970: x_login_id => l_current_login_id,
4971: x_resource_id => l_current_resource_id,
4972: x_user_status => l_current_user_status

Line 5111: AMV_UTILITY_PVT.Get_UserInfo(

5107: END IF;
5108: -- Initialize API return status to success
5109: x_return_status := FND_API.G_RET_STS_SUCCESS;
5110: -- Get the current (login) user id.
5111: AMV_UTILITY_PVT.Get_UserInfo(
5112: x_user_id => l_current_user_id,
5113: x_login_id => l_current_login_id,
5114: x_resource_id => l_current_resource_id,
5115: x_user_status => l_current_user_status

Line 5152: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN

5148: l_current_login_id := -1;
5149: l_current_user_id := -1;
5150: END IF;
5151: -- Check if the group id is valid
5152: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
5153: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5154: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5155: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
5156: FND_MSG_PUB.Add;

Line 5275: AMV_UTILITY_PVT.Get_UserInfo(

5271: -- Initialize API return status to success
5272: x_return_status := FND_API.G_RET_STS_SUCCESS;
5273: x_result_flag := FND_API.G_FALSE;
5274: -- Get the current (login) user id.
5275: AMV_UTILITY_PVT.Get_UserInfo(
5276: x_user_id => l_current_user_id,
5277: x_login_id => l_current_login_id,
5278: x_resource_id => l_current_resource_id,
5279: x_user_status => l_current_user_status

Line 5384: AMV_UTILITY_PVT.Get_UserInfo(

5380: END IF;
5381: -- Initialize API return status to success
5382: x_return_status := FND_API.G_RET_STS_SUCCESS;
5383: -- Get the current (login) user id.
5384: AMV_UTILITY_PVT.Get_UserInfo(
5385: x_user_id => l_current_user_id,
5386: x_login_id => l_current_login_id,
5387: x_resource_id => l_current_resource_id,
5388: x_user_status => l_current_user_status

Line 5445: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(l_access_obj.user_or_group_id)

5441: END IF;
5442: IF (l_access_obj.access_id = FND_API.G_MISS_NUM) THEN
5443: IF (l_access_obj.user_or_group_type = G_GROUP_ARC_TYPE) THEN
5444: -- Check if the Group id is valid
5445: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(l_access_obj.user_or_group_id)
5446: <> TRUE) THEN
5447: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5448: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5449: FND_MESSAGE.Set_Token('ID',

Line 5457: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(l_access_obj.user_or_group_id)

5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;
5455: ELSIF (l_access_obj.user_or_group_type = G_USER_ARC_TYPE) THEN
5456: -- Check if the resource id is valid
5457: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(l_access_obj.user_or_group_id)
5458: <> TRUE) THEN
5459: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5460: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
5461: FND_MESSAGE.Set_Token('ID',

Line 5476: IF (AMV_UTILITY_PVT.IS_ITEMIDVALID(

5472: RAISE FND_API.G_EXC_ERROR;
5473: END IF;
5474: IF (l_access_obj.access_to_table_code = G_ITEM_ARC_TYPE) THEN
5475: -- Check if the item id is valid
5476: IF (AMV_UTILITY_PVT.IS_ITEMIDVALID(
5477: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5478: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_name('AMV','AMV_INVALID_ITEM_ID');
5480: FND_MESSAGE.Set_Token('ID',

Line 5488: IF (AMV_UTILITY_PVT.IS_CHANNELIDVALID(

5484: RAISE FND_API.G_EXC_ERROR;
5485: END IF;
5486: ELSIF (l_access_obj.access_to_table_code = G_CHAN_ARC_TYPE) THEN
5487: -- Check if the channel id is valid
5488: IF (AMV_UTILITY_PVT.IS_CHANNELIDVALID(
5489: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5490: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5491: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CHANEL_ID');
5492: FND_MESSAGE.Set_Token('ID',

Line 5500: IF (AMV_UTILITY_PVT.IS_CATEGORYIDVALID(

5496: RAISE FND_API.G_EXC_ERROR;
5497: END IF;
5498: ELSIF (l_access_obj.access_to_table_code = G_CATE_ARC_TYPE) THEN
5499: -- Check if the category id is valid
5500: IF (AMV_UTILITY_PVT.IS_CATEGORYIDVALID(
5501: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5502: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5503: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
5504: FND_MESSAGE.Set_Token('ID',

Line 5512: IF (AMV_UTILITY_PVT.IS_APPLIDVALID(

5508: RAISE FND_API.G_EXC_ERROR;
5509: END IF;
5510: ELSIF (l_access_obj.access_to_table_code = G_APPL_ARC_TYPE) THEN
5511: -- Check if the application id is valid
5512: IF (AMV_UTILITY_PVT.IS_APPLIDVALID(
5513: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5515: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPLICATION_ID');
5516: FND_MESSAGE.Set_Token('ID',

Line 5692: AMV_UTILITY_PVT.Get_UserInfo(

5688: END IF;
5689: -- Initialize API return status to success
5690: x_return_status := FND_API.G_RET_STS_SUCCESS;
5691: -- Get the current (login) user id.
5692: AMV_UTILITY_PVT.Get_UserInfo(
5693: x_user_id => l_current_user_id,
5694: x_login_id => l_current_login_id,
5695: x_resource_id => l_current_resource_id,
5696: x_user_status => l_current_user_status

Line 6402: AMV_UTILITY_PVT.Get_UserInfo(

6398: END IF;
6399: -- Initialize API return status to success
6400: x_return_status := FND_API.G_RET_STS_SUCCESS;
6401: -- Get the current (login) user id.
6402: AMV_UTILITY_PVT.Get_UserInfo(
6403: x_user_id => l_current_user_id,
6404: x_login_id => l_current_login_id,
6405: x_resource_id => l_current_resource_id,
6406: x_user_status => l_current_user_status

Line 6589: AMV_UTILITY_PVT.Get_UserInfo(

6585: END IF;
6586: -- Initialize API return status to success
6587: x_return_status := FND_API.G_RET_STS_SUCCESS;
6588: -- Get the current (login) user id.
6589: AMV_UTILITY_PVT.Get_UserInfo(
6590: x_user_id => l_current_user_id,
6591: x_login_id => l_current_login_id,
6592: x_resource_id => l_current_resource_id,
6593: x_user_status => l_current_user_status

Line 6833: AMV_UTILITY_PVT.Get_UserInfo(

6829: FND_API.G_FALSE
6830: );
6831: */
6832: -- Get the current (login) user id.
6833: AMV_UTILITY_PVT.Get_UserInfo(
6834: x_user_id => l_current_user_id,
6835: x_login_id => l_current_login_id,
6836: x_resource_id => l_current_resource_id,
6837: x_user_status => l_current_user_status

Line 7080: AMV_UTILITY_PVT.Get_UserInfo(

7076: FND_API.G_FALSE
7077: );
7078: */
7079: -- Get the current (login) user id.
7080: AMV_UTILITY_PVT.Get_UserInfo(
7081: x_user_id => l_current_user_id,
7082: x_login_id => l_current_login_id,
7083: x_resource_id => l_current_resource_id,
7084: x_user_status => l_current_user_status