APPS.AHL_PRD_WO_LOGIN_PVT dependencies on FND_PROFILE

Line 195: IF (NVL(FND_PROFILE.value('AHL_MANUAL_RES_TXN'),'N') = 'Y') OR

191:
192: -- Check if login/logout enabled.
193: l_user_role := get_user_role();
194:
195: IF (NVL(FND_PROFILE.value('AHL_MANUAL_RES_TXN'),'N') = 'Y') OR
196: (l_user_role = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
197: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;

Line 1570: IF (NVL(FND_PROFILE.value('AHL_MANUAL_RES_TXN'),'N') = 'Y') OR

1566: l_user_role := get_user_role();
1567:
1568: /* THis validation is not needed. Data Clerk can complete WO in which case all users
1569: should be logged out
1570: IF (NVL(FND_PROFILE.value('AHL_MANUAL_RES_TXN'),'N') = 'Y') OR
1571: (l_user_role = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
1572: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;

Line 2906: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') OR

2902:
2903: END IF;
2904:
2905: -- Check if login enabled.
2906: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') OR
2907: (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
2908: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
2909: FND_MSG_PUB.ADD;
2910: Return FND_API.G_FALSE;

Line 3097: IF nvl(fnd_profile.value('AHL_ALLOW_MULTI_RESRC_LOGIN'), 'N') = 'Y' THEN

3093:
3094: /*
3095: -- If user qualifies for multiple resource requirements within the same operation and
3096: -- profile 'AHL_ALLOW_MULTI_RESRC_LOGIN' = 'Y then do not allow WO login.
3097: IF nvl(fnd_profile.value('AHL_ALLOW_MULTI_RESRC_LOGIN'), 'N') = 'Y' THEN
3098: OPEN c_check_res_multiple_wo(l_employee_id, l_wip_entity_id);
3099: FETCH c_check_res_multiple_wo INTO l_junk;
3100: IF (c_check_res_multiple_wo%FOUND) THEN
3101: -- disable login at WO level.

Line 3169: IF nvl(fnd_profile.value('AHL_ALLOW_MULTI_RESRC_LOGIN'), 'N') = 'Y' THEN

3165:
3166: /*
3167: -- If user qualifies for multiple resource requirements within the same operation and
3168: -- profile 'AHL_ALLOW_MULTI_RESRC_LOGIN' = 'Y then do not allow WO-OP login.
3169: IF nvl(fnd_profile.value('AHL_ALLOW_MULTI_RESRC_LOGIN'), 'N') = 'Y' THEN
3170: OPEN c_check_res_multiple_op(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3171: FETCH c_check_res_multiple_op INTO l_junk;
3172: IF (c_check_res_multiple_op%FOUND) THEN
3173: -- disable login at WO level.

Line 3556: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') THEN

3552:
3553: BEGIN
3554: --Return FND_API.G_FALSE;
3555: -- Check if login enabled.
3556: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') THEN
3557: Return FND_API.G_FALSE;
3558: END IF;
3559:
3560: -- Check required parameters.

Line 3771: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') THEN

3767: WHERE WLGN.operation_resource_id = AOR.operation_resource_id(+)
3768: AND WLGN.employee_id = c_employee_id
3769: AND WLGN.logout_date IS NULL; -- employee logged in.
3770: BEGIN
3771: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') THEN
3772: Return FND_API.G_FALSE;
3773: END IF;
3774:
3775: -- Check required parameters.