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.AHL_PRD_WO_LOGIN_PVT dependencies on FND_FUNCTION

Line 640: p_fnd_function_name => p_user_role);

636: p_workorder_id => p_workorder_id,
637: p_operation_seq_num => p_operation_seq_num,
638: p_resource_seq_num => p_resource_seq_num,
639: p_resource_id => p_resource_id,
640: p_fnd_function_name => p_user_role);
641:
642: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
643: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
644: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);

Line 1000: p_fnd_function_name => p_user_role);

996: -- Call procedure to check if login allowed or not.
997: l_login_allowed_flag := Is_Login_Allowed(p_employee_id => p_employee_id,
998: p_workorder_id => p_workorder_id,
999: p_operation_seq_num => p_operation_seq_num,
1000: p_fnd_function_name => p_user_role);
1001:
1002: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1003: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_login',
1004: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);

Line 1292: p_fnd_function_name => p_user_role);

1288:
1289: -- Call procedure to check if login allowed or not.
1290: l_login_allowed_flag := Is_Login_Allowed(p_employee_id => p_employee_id,
1291: p_workorder_id => p_workorder_id,
1292: p_fnd_function_name => p_user_role);
1293:
1294: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1295: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1296: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);

Line 2311: -- p_fnd_function_name Input FND function name.

2307: -- Start of Comments --
2308: -- Function name : Get_User_Role
2309: --
2310: -- Parameters :
2311: -- p_fnd_function_name Input FND function name.
2312: --
2313: -- Description : This function is used to retrieve the role associated with the current
2314: -- user - it could be a Production Tech, Production Data Clerk or
2315: -- Production Transit Tech.

Line 2332: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)) THEN

2328: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.Start',
2329: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Get_User_Role');
2330: END IF;
2331:
2332: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)) THEN
2333: -- Technician Role.
2334: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2335: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN
2336: -- Data Clerk Role.

Line 2335: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN

2331:
2332: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)) THEN
2333: -- Technician Role.
2334: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2335: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN
2336: -- Data Clerk Role.
2337: l_user_role := AHL_PRD_UTIL_PKG.G_DATA_CLERK;
2338: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_LINE_TECH)) THEN
2339: -- Transit Check Role.

Line 2338: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_LINE_TECH)) THEN

2334: l_user_role := AHL_PRD_UTIL_PKG.G_TECH_MYWO;
2335: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_DATA_CLERK)) THEN
2336: -- Data Clerk Role.
2337: l_user_role := AHL_PRD_UTIL_PKG.G_DATA_CLERK;
2338: ELSIF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_LINE_TECH)) THEN
2339: -- Transit Check Role.
2340: l_user_role := AHL_PRD_UTIL_PKG.G_LINE_TECH;
2341: END IF;
2342:

Line 2612: -- p_fnd_function_name -- Mandatory fnd_function to identify user role.

2608: -- p_employee_id -- Optional Input Employee Id.
2609: -- p_wip_entity_id -- Mandatory Workorder ID.
2610: -- p_operation_seq_num -- Mandatory Operation Seq Number
2611: -- p_resource_seq_num -- Mandatory Resource ID.
2612: -- p_fnd_function_name -- Mandatory fnd_function to identify user role.
2613: --
2614: -- Description : This function is used to determine if a given technician is
2615: -- allowed to login to a particular workorder/operation/oper-resource.
2616: -- User is allowed to login only if value of the profile

Line 2631: p_fnd_function_name IN VARCHAR2)

2627: p_workorder_id IN NUMBER,
2628: p_operation_seq_num IN NUMBER := NULL,
2629: p_resource_seq_num IN NUMBER := NULL,
2630: p_resource_id IN NUMBER := NULL,
2631: p_fnd_function_name IN VARCHAR2)
2632: RETURN VARCHAR2 IS
2633:
2634: -- get WO status.
2635: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS

Line 2870: l_fnd_function_name VARCHAR2(100);

2866: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2867: l_resource_id NUMBER;
2868: l_employee_name per_people_f.full_name%TYPE;
2869:
2870: l_fnd_function_name VARCHAR2(100);
2871:
2872: BEGIN
2873:
2874: -- log debug message.

Line 2893: 'p_fnd_function_name:' || p_fnd_function_name);

2889: 'p_resource_seq_num:' || p_resource_seq_num);
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_resource_id:' || p_resource_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_fnd_function_name:' || p_fnd_function_name);
2894:
2895: END IF;
2896:
2897: -- Check if login enabled.

Line 2899: (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN

2895: END IF;
2896:
2897: -- Check if login enabled.
2898: IF (NVL(FND_PROFILE.value('AHL_PRD_MANUAL_RES_TXN'),'N') = 'Y') OR
2899: (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_DATA_CLERK) THEN
2900: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_AUTOTXN_DSBLD');
2901: FND_MSG_PUB.ADD;
2902: Return FND_API.G_FALSE;
2903: END IF;

Line 3015: IF (p_fnd_function_name IS NULL) THEN

3011: FND_MSG_PUB.ADD;
3012: RETURN FND_API.G_FALSE;
3013: END IF;
3014:
3015: IF (p_fnd_function_name IS NULL) THEN
3016: l_fnd_function_name := get_user_role();
3017: ELSE
3018: l_fnd_function_name := p_fnd_function_name;
3019: END IF;

Line 3016: l_fnd_function_name := get_user_role();

3012: RETURN FND_API.G_FALSE;
3013: END IF;
3014:
3015: IF (p_fnd_function_name IS NULL) THEN
3016: l_fnd_function_name := get_user_role();
3017: ELSE
3018: l_fnd_function_name := p_fnd_function_name;
3019: END IF;
3020:

Line 3018: l_fnd_function_name := p_fnd_function_name;

3014:
3015: IF (p_fnd_function_name IS NULL) THEN
3016: l_fnd_function_name := get_user_role();
3017: ELSE
3018: l_fnd_function_name := p_fnd_function_name;
3019: END IF;
3020:
3021: IF (l_fnd_function_name IS NULL) THEN
3022: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_FUNC_NULL');

Line 3021: IF (l_fnd_function_name IS NULL) THEN

3017: ELSE
3018: l_fnd_function_name := p_fnd_function_name;
3019: END IF;
3020:
3021: IF (l_fnd_function_name IS NULL) THEN
3022: FND_MESSAGE.set_name('AHL', 'AHL_PRD_LGN_FUNC_NULL');
3023: FND_MSG_PUB.ADD;
3024: Return FND_API.G_FALSE;
3025: END IF;

Line 3031: l_fnd_function_name);

3027: -- Debug Checkpoint.
3028: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3029: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3030: 'After unit lock check, user role check.. starting qualification checks for function:' ||
3031: l_fnd_function_name);
3032: END IF;
3033:
3034: -- validate login into workorder/operation/operation-resource.
3035: IF (p_operation_seq_num IS NULL) THEN

Line 3069: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3065: END IF; -- c_check_res_reqd.
3066: CLOSE c_check_res_reqd;
3067:
3068: -- Validate qualification to login into a WO in Technician case.
3069: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3070: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3071: -- validate user qualifies for at least one resource requirement within each operation.
3072: FOR operation_rec IN c_get_workorder_oper(l_wip_entity_id) LOOP
3073: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);

Line 3070: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3066: CLOSE c_check_res_reqd;
3067:
3068: -- Validate qualification to login into a WO in Technician case.
3069: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3070: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3071: -- validate user qualifies for at least one resource requirement within each operation.
3072: FOR operation_rec IN c_get_workorder_oper(l_wip_entity_id) LOOP
3073: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, operation_rec.operation_seq_num);
3074: FETCH c_qualified_for_one_res INTO l_junk;

Line 3084: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3080: RETURN FND_API.G_FALSE;
3081: END IF; -- c_qualified_for_one_ops
3082: CLOSE c_qualified_for_one_res;
3083: END LOOP; -- operation_rec
3084: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3085:
3086: /*
3087: -- If user qualifies for multiple resource requirements within the same operation and
3088: -- profile 'AHL_ALLOW_MULTI_RESRC_LOGIN' = 'Y then do not allow WO login.

Line 3142: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3138: END IF;
3139:
3140:
3141: -- Validate qualification to login into a Operation in Technician case.
3142: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3143: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3144: -- validate user qualifies for at least one resource requirement for the operation.
3145: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3146: FETCH c_qualified_for_one_res INTO l_junk;

Line 3143: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3139:
3140:
3141: -- Validate qualification to login into a Operation in Technician case.
3142: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3143: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3144: -- validate user qualifies for at least one resource requirement for the operation.
3145: OPEN c_qualified_for_one_res(l_employee_id, l_wip_entity_id, p_operation_seq_num);
3146: FETCH c_qualified_for_one_res INTO l_junk;
3147: IF (c_qualified_for_one_res%NOTFOUND) THEN

Line 3156: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3152: FND_MSG_PUB.ADD;
3153: RETURN FND_API.G_FALSE;
3154: END IF; -- c_qualified_for_one_res
3155: CLOSE c_qualified_for_one_res;
3156: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3157:
3158: /*
3159: -- If user qualifies for multiple resource requirements within the same operation and
3160: -- profile 'AHL_ALLOW_MULTI_RESRC_LOGIN' = 'Y then do not allow WO-OP login.

Line 3217: -- Commented l_fnd_function_name validation to fix bug# 5015149.

3213: END IF; -- c_is_resource_valid
3214: CLOSE c_is_resource_valid;
3215:
3216: -- Validate qualification in case of technician.
3217: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3218: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3219: OPEN c_qualify_res(l_employee_id, l_wip_entity_id, p_operation_seq_num,
3220: l_resource_id);
3221: FETCH c_qualify_res INTO l_junk;

Line 3218: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN

3214: CLOSE c_is_resource_valid;
3215:
3216: -- Validate qualification in case of technician.
3217: -- Commented l_fnd_function_name validation to fix bug# 5015149.
3218: -- IF (l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO) THEN
3219: OPEN c_qualify_res(l_employee_id, l_wip_entity_id, p_operation_seq_num,
3220: l_resource_id);
3221: FETCH c_qualify_res INTO l_junk;
3222: IF (c_qualify_res%FOUND) THEN

Line 3232: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO

3228: FND_MSG_PUB.ADD;
3229: RETURN FND_API.G_FALSE;
3230: END IF;
3231: CLOSE c_qualify_res;
3232: -- END IF; -- l_fnd_function_name = AHL_PRD_UTIL_PKG.G_TECH_MYWO
3233:
3234: END IF; -- p_resource_id IS NULL
3235:
3236: END IF; -- operation_seq_num is not null.

Line 3298: p_fnd_function_name => p_function_name

3294: LOOP
3295: p_x_wos(i).is_login_allowed := Is_Login_Allowed(
3296: p_employee_id => p_employee_id,
3297: p_workorder_id => p_x_wos(i).workorder_id,
3298: p_fnd_function_name => p_function_name
3299: );
3300: END LOOP;
3301: END IF;
3302:

Line 3337: p_fnd_function_name => p_function_name

3333: p_employee_id => p_employee_id,
3334: p_workorder_id => p_workorder_id,
3335: p_operation_seq_num => p_x_op_res(i).operation_seq_num,
3336: p_resource_id => p_x_op_res(i).resource_id,
3337: p_fnd_function_name => p_function_name
3338: );
3339: END LOOP;
3340: END IF;
3341: