818: sysdate,
819: 1,
820: 'R',
821: sysdate,
822: fnd_global.user_id,
823: sysdate,
824: fnd_global.user_id,
825: fnd_global.login_id
826: );
820: 'R',
821: sysdate,
822: fnd_global.user_id,
823: sysdate,
824: fnd_global.user_id,
825: fnd_global.login_id
826: );
827:
828: -- log debug message.
821: sysdate,
822: fnd_global.user_id,
823: sysdate,
824: fnd_global.user_id,
825: fnd_global.login_id
826: );
827:
828: -- log debug message.
829: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1139: sysdate,
1140: 1,
1141: 'O',
1142: sysdate,
1143: fnd_global.user_id,
1144: sysdate,
1145: fnd_global.user_id,
1146: fnd_global.login_id);
1147:
1141: 'O',
1142: sysdate,
1143: fnd_global.user_id,
1144: sysdate,
1145: fnd_global.user_id,
1146: fnd_global.login_id);
1147:
1148: -- log debug message.
1149: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1142: sysdate,
1143: fnd_global.user_id,
1144: sysdate,
1145: fnd_global.user_id,
1146: fnd_global.login_id);
1147:
1148: -- log debug message.
1149: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1150: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.End',
1431: sysdate,
1432: 1,
1433: 'W',
1434: sysdate,
1435: fnd_global.user_id,
1436: sysdate,
1437: fnd_global.user_id,
1438: fnd_global.login_id);
1439:
1433: 'W',
1434: sysdate,
1435: fnd_global.user_id,
1436: sysdate,
1437: fnd_global.user_id,
1438: fnd_global.login_id);
1439:
1440: -- log debug message.
1441: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1434: sysdate,
1435: fnd_global.user_id,
1436: sysdate,
1437: fnd_global.user_id,
1438: fnd_global.login_id);
1439:
1440: -- log debug message.
1441: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1442: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.End',
2404:
2405: BEGIN
2406: -- Check for NULL value.
2407: IF (p_employee_number IS NULL) THEN
2408: OPEN c_get_current_employee_id(FND_GLOBAL.USER_ID);
2409: FETCH c_get_current_employee_id INTO l_employee_id;
2410: IF (c_get_current_employee_id%NOTFOUND) THEN
2411: l_employee_id := NULL;
2412: END IF;